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
 SQL Server Development (2000)
 Time to live

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-27 : 10:14:51
Michael Satterfield writes "Hey guys,
I have a question - this is what i have

customer (table)
listing (table)
expired_listings (table)

I need a record to me moved out of the listing table into the "expired_listings table" (to keep track of the customers expired listings) after 30 days. I have tried for almost a week to find out how to do this.... please help.

Thank you soooooo much!

Michael Satterfield

win2000 advanced srv
sql srv ver 7.0"
   

- Advertisement -