Henk, in most cases your select will product good enough results. But if a shop have many sessions with small ammounts of data to backup (RDBMS logs or workstations for example) your query results might become inaccurate. Instead of "select sum(cast(bytes/1024/1024/1024 as decimal))" use "select cast(sum(bytes)/1024/1024/1024 as decimal)".
Zlatko Krastev IT Consultant Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: Select statement question Wayne, > Can anyone help me with a select query that will tell me how much data I've > backed up in the last 24 hours? select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB Backup" - from summary where start_time>=current_timestamp - 1 day and activity='BACKUP' Cheers, Henk ten Have
