Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 'My Question'

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-05-26 : 07:05:09
Saurabh writes "on every login to application developed in VB I have to check the previous login date . if the diference is more than 30 hours then I have to copy some selected records from one table to another database how can I do this using SQL Server"

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-05-26 : 07:22:01
look at the datediff function in books online

Duane.
Go to Top of Page
   

- Advertisement -