how to move the records to another table that exceeds 10 days

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 1

Do you have any created date or updated date in the table? That would be the right key to purge the data.

kuppurajm SSCommitted Points: 1593 More actions · Answer 2

SSCommitted

Points: 1593

May 16, 2011 at 10:49 pm

I have created date in my table.

Latheesh NK SSCertifiable Points: 6559 More actions · Answer 3

then its pretty easy as it is to move the records with the created date difference from the current date exceeds 10 days.

Use DateDiff function for the same.