You do have options. DTS and INSERT...SELECT come to mind. I'm not sure about BCP. This would require that you get the data out of SQL Server only to pull it back in.

David does bring up a good point. Watch your transaction log. You don't want to fill it up but you might have to live with it growing due to this process. Although 25K isn't really a lot of rows to be dealing with.

-Mike


>I guess I didn't explain this very clearly: There is one SQL database containing separate tables for history and active data. The data has always been separate since we started keeping history in 2.x tables back in the early 1990s. There is no business reason to combine them now, and lots of very good reasons to keep them separate. I don't want to re-write the entire application, only the monthly close. I actually thought there would be several options but maybe not...