I would just mark them with a code for the closing month and leave them where they are.
>I'm supporting a couple of applications that have an active data set and a history data set in the same SQL database. The table structures for each set are identical. What is the best way to move the completed records to history at the monthly close? There could be 25K records to archive in the largest tables. Some tables have multiple indices.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown