Deleting Data

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

DELETE FROM dbo.tbl

WHERE dt >= DATEADD(M, -2, GETDATE())

TST1 SSCommitted Points: 1798 More actions · Answer 2

Hi thanks.

I am assuming if I change the -2 to -1 it will be leaving just 1 month of data behind?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Yes.

Now you need to define what months means in this case.

Change the where to a select to see exactly what it does and adjust accordingly.

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

Try it out and see what values you are using.

select DATEADD(M, -2, GETDATE()), DATEADD(M, -1, GETDATE())

Remember that if you don't understand the code you are running you could be running something that you really don't want to. 😉

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

TST1 SSCommitted Points: 1798 More actions · Answer 5

SSCommitted

Points: 1798

November 16, 2011 at 7:56 am

Thanks again. I shall have a little play around.