select node summary
2004-11-18 12:52:58
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
joni.moyer AT highmark DOT com
********************************
|
|
|