Post reply

Query to get Login details

  • October 15, 2008 at 11:02 pm

    #194664

    I have a table storing user login & logout details with userid, username, login & logout datetime details.

    Lets take that a user has logged in 20 times. I want to get the adjacent logged in datetime of time difference with 20 minutes. That is, the time difference between the adjacent login is 20 minutes.

  • October 15, 2008 at 11:19 pm

    #885638

    Help us help you. There really isn't enough info in your post to work with. Please take the time to read the following article:

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Follow the guidelines in the article and report your question in this thread. You will most likely find that you will get a significantly better response that will truely be helpful.

    😎

Viewing 2 posts - 1 through 1 (of 1 total)

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