User Profile

Collapse

Profile Sidebar

Collapse
bb02
bb02
Last Activity: Feb 27 '07, 07:09 PM
Joined: Dec 28 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • bb02
    replied to Time Intervals
    in SQL Server
    Almaz,

    Thanks so much. Worked perfectly. The logic is great.
    See more | Go to post

      Leave a comment:

    • bb02
      started a topic Time Intervals
      in SQL Server

      Time Intervals

      I have a login audit table that has a LoginDateTime and a LogoutDateTime. I am wanting to count the number of users whose datetime range falls between 15 minute intervals each day.

      For example:

      User 1 logs in at 0800 and logs out at 08:10
      User 2 logs in at 0805 and log out at 09:00

      I am wanting the results to appear like this:

      0800 - 2 (since both users were in during this time)...
      See more | Go to post
      No activity results to display
      Show More
      Working...