if i want to create a procedure to truncate 12months old records in a table what could be the condition...? like Set Month = Dateadd(month, -12, Dateadd(day, -1, @intr). can you suggest..?
DELETE FROM MyTable WHERE MyDate < DATEADD(year, -1, GetDate())
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip