August 6, 2004 at 3:36 am
Hi Folks,
Hope you may be able to help. I have a table that records the last time someone logged on to the system. it is a very simple table just UserID (Char 20) and LastLogin (DateTime 8)
Users can log on and logout at various times during the week. What I need to retrieve is a list of User Id's and the last time they logged on.
August 6, 2004 at 5:16 am
select userid, max(lastlogin) from yoursimpletable
group by userid
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 6, 2004 at 7:30 am
Chris you are a star. Thank you
August 6, 2004 at 2:29 pm
No problem.
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply