Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jonmccon

  1. jonmccon

    Insert multiple rows into composite primary key

    Thanks yet again, Terry.
  2. jonmccon

    Insert multiple rows into composite primary key

    I am trying to insert data from 2 tables (tblContacts and tblPermission)into another table (tblUserPermissions). The columns to which I need to insert the data in tblUserPermission (ContactID, and PermissionID) make up its primary key. Can anyone help me with this? Nothing I have tried has...
  3. jonmccon

    login times out

    I hope someone can point me in the right direction as I am a bit confused. I have an application that accesses SQL Server 2000 to validate app logins. Occasionally, the login process times out. This usually occurs when that login has not been used in some time. I used Windows System Monitor...
  4. jonmccon

    Calculating time and group by

    Terry, You my dear are a godsend. THANK YOU, THANK YOU, THANK YOU!!! Jonna
  5. jonmccon

    Calculating time and group by

    Can't thank you enough for the help Terry. The following query misses many of the sessions. Some dates are missed altogether. What I really need is a DISTINCT function on T.UserTimeLogIn, but then I have to include it in the GROUP BY statement which screws the results up. Any ideas? Going...
  6. jonmccon

    Calculating time and group by

    Thanks for the help. I have tried the DATEDIFF function as shown below. It doesn't roll up different sessions. If I logged on 5 times in a day, it shows me the total time of each session. I want to see the total time for all sessions for a user/day. SELECT T.UserTimeLogIn...
  7. jonmccon

    Calculating time and group by

    I am trying to calculate the total time a user has been logged on to an appilcation for the day. The beginnings of my query looks like this: SELECT T.UserTimeLogIn,T.UserTimeLogOut, C.ContactFirstName, C.ContactLastName, T.ContactID FROM T INNER JOIN C ON T.ContactID = C.ContactID WHERE...
See more

Part and Inventory Search

Back
Top