• You might consider looking into partitioning. Partition your table so that the rows you want to get rid of are in their own partition then use SWITCH to put them into a whole different table, then drop that table. I've read about doing this several times although right now I can't think where. You should be able to find it easily enough. You might consider looking at Kimberly Tripps blog, she does a lot on partitioning.

    The last half of this article seems to do what you are looking for.

    http://www.sqlskills.com/BLOGS/KIMBERLY/post/Clarifying-LEFT-and-RIGHT-in-the-defintion-of-a-PARTITION-FUNCTION-in-SQL-Server-2005.aspx

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]