On Thu, 07 Apr 2005, Loon, E.J. van - SPLXM might have said: > Hi *SM-ers! > Please help me with this and take the time to read this request!!!!
tsm: ADSM>select activity, cast ((end_time) as date) as "Date" ,(examined/cast((end_time-s tart_time) seconds as decimal(18,13)) *3600) "Objects Examined Up/Hr" from summa ry where activity='EXPIRATION' and days (end_time)-days(start_time)=0 ACTIVITY Date Objects Examined Up/Hr ------------------ ---------- --------------------------------- EXPIRATION 2005-03-08 1069200 EXPIRATION 2005-03-09 1101600 EXPIRATION 2005-03-10 842400 EXPIRATION 2005-03-11 889200 EXPIRATION 2005-03-12 770400 EXPIRATION 2005-03-13 781200 EXPIRATION 2005-03-14 828000 EXPIRATION 2005-03-15 1065600 EXPIRATION 2005-03-16 1130400 EXPIRATION 2005-03-17 842400 EXPIRATION 2005-03-18 633600 EXPIRATION 2005-03-20 558000 EXPIRATION 2005-03-21 702000 EXPIRATION 2005-03-22 1080000 EXPIRATION 2005-03-23 918000 EXPIRATION 2005-03-24 849600 EXPIRATION 2005-03-25 918000 EXPIRATION 2005-03-26 748800 EXPIRATION 2005-03-27 864000 EXPIRATION 2005-03-28 795600 EXPIRATION 2005-03-29 1108800 EXPIRATION 2005-03-30 1134000 EXPIRATION 2005-03-31 831600 EXPIRATION 2005-04-01 896400 EXPIRATION 2005-04-02 770400 EXPIRATION 2005-04-03 788400 EXPIRATION 2005-04-04 777600 EXPIRATION 2005-04-05 1249200 EXPIRATION 2005-04-06 1000800 When you get your results compiled, please send the results back to the list. Mike
