Deleting old Records

[bjr149]

I need to have a method in place to delete old records off of a staging table. I have this code that works for records that are over 4 months old

delete from vcsv_payment_stage
where time_moved < dateadd(mm, -4, getdate())


I want to extend this to years.. Is it just yy instead of mm??

 

[SQLDenis]

????
If you remove everything that is older than 4 months there would be nothing left that is older than a year right?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[gmmastros]

You should always test your deletes before you do them.

[!]Select *[/!] from vcsv_payment_stage
where time_moved < dateadd(year, -4, getdate())

If you get the data you expect, then change it to...

[!]delete[/!] from vcsv_payment_stage
where time_moved < dateadd(year, -4, getdate())

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom