Sorting by date and time

Question

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 1

Try something like this:

select userid, max([datetime]), min([datetime]) from test group by userid

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 2

If you want it for each day then you try something like this.

select userid, max([datetime]), min([datetime]) from test group by userid, convert(char(10),[datetime])

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

5409045121009-7368 SSCoach Points: 15740 More actions · Answer 3

An article which maybe of interest to you about "The Call-Costs Problem".

Title: Counting the Costs

andystob Valued Member Points: 57 More actions · Answer 4

Valued Member

Points: 57

April 28, 2003 at 4:41 pm

cheers mate, that hit the spot!