Archiving rows using a Date Field

[Tom Carter]

Hi all,

Would anyone be able to point me in the right direction for creating a procedure to archive rows using a DATE field value as the determinant for selecting the rows to be moved to a backup table?

I'd really appreciate any assistance that anyone can provide.

Thanks,
Tom C.

[JoanO]

You can use select into to put the data in another table...for example, this query takes data out of tblmain where the year of submitted_dt is > 1996 and puts it into a table called newtablename.

select *
into newtablename
from tblmain
where datepart(year, submitted_dt) > 1996

Then you would have to delete the data in the original table changing the select to a delete. (backup the table before doing the delete and make sure the row counts for the select and the delete are the same.)

------------
Tom Carter at 6/6/00 5:16:54 PM

Hi all,

Would anyone be able to point me in the right direction for creating a procedure to archive rows using a DATE field value as the determinant for selecting the rows to be moved to a backup table?

I'd really appreciate any assistance that anyone can provide.

Thanks,
Tom C.