Urgent:Data Purging of previous month
-
kindly tel me how to handle Data Purging of previous month... We want to have the data of current month only...
I assume you have some kind of added date on your table(s), otherwise how will youi know the age of the data, but anyway:
delete tablea where addeddate < dateadd(month,-1,getdate())This will delete anything over 1 month old today. Its easy enough to work on a month end/month start basis, I'll leave that for you to work out. Also, if you have referential integrity between table you need to do the deletes in the correct order.Bob Ashfield Consultants Ltd
-
kindly tel me how to handle Data Purging of previous month... We want to have the data of current month only...
Ah, you cross posted. Please don't do that
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )