DateTime

Hi All,

I need to purge the table but leave 2 most current years worth of data. Hod do I do that?

Delete those data older than 2 years. Does the table have datetime column? If so, you can use dateadd function in where clause to get old data.