Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Need to return values with multiple entries only Expand / Collapse
Posted Wednesday, May 14, 2014 8:29 AM


Group: General Forum Members
Last Login: Yesterday @ 3:14 PM
Points: 2,872, Visits: 4,361
If you just want the total hours, you don't need to return all the rows at all, simply total the time differences. This is very easy if there are always matching check-in and check-out records.

SQL DBA,SQL Server MVP('07, '08, '09)

Carl Sagan said: "There is no such thing as a dumb question." Sagan obviously never watched a congressional hearing!
Post #1570872
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse