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!
-
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!
-
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...- jonmccon
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
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...- jonmccon
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
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...- jonmccon
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
