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
Author
Message
Posted Wednesday, May 14, 2014 8:29 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:39 AM
Points: 3,058, Visits: 4,688
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)

"If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them." James Blackburn, in closing argument in the "Fatal Vision" murders trial
Post #1570872
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse