Hello All! I believe that I am getting the syntax of a select statement wrong for summarizing the backup information summary for all nodes that begin with ln* from 11/12/2004 - 11/13/2004. Here is what I have so far:
select entity as node_name, date(start_date) as date, cast(activity as varchar(10)) as activity, time(start_time) as start, time(end_time) as end, cast(bytes/1000000) as decimal(6,0)) as megabytes, cast(affected as decimal(7,0)) as files successful from summary where date=11/12/2004 and activity='BACKUP' and node_name='LN*' order by node_name Would anyone happen to know what I am doing wrong? I just can't seem to get this query to work. Thank you in advance! ******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ********************************
