Help - Query for Max concurrent users from a login and logout table

• dcw8888

  SSC Eights!

  Points: 885

  More actions

  May 28, 2010 at 3:16 pm

  #98751

  Hi Everyone,

  I have a table that contains the login and logout time and here are the following columns and data:

  ID, Action, Time, UserName

  1, Login, 2010-05-01 13:00:00, abc123

  2. Logout, 2010-05-01 14:00:00, abc123

  3. Login, 2010-05-01 13:30:00, def234

  4. Logout, 2010-05-01 14:10:00, def234

  .

  .

  .

  .

  .

  .

  Can anyone help me write a query that will show max concurrent users let say for the day of May 1, 2010?

  Much appreciated with all your help! [Smile]

• Ben Teraberry

  SSChampion

  Points: 11845

  More actions

  May 28, 2010 at 3:22 pm

  #1174158

  Please don't re-post the same question in different places.

  Original post here.

  └> bt
  

  ---

  
  Forum Etiquette: How to post data/code on a forum to get the best help[/url]