I have a database called "test" that has a table within it called "5Cycle". We have hundreds of thousands of records that I want to archive down. I'd like to do this by year so I need to delete anything older than a certain date. The date column is "TestDate" formatted YYYY-MM-DD 00:00:00:000
How do I select and delete anything older than 1/1/2010?