bluenoser337
Programmer
I have a single table in a SQLServer7.0 application that gets about 10,000 rows entered automatically each day (as various parts are manufactured). As time passes, the queries become slow to impossible for daily, weekly, etc reporting. I'd like to have the table contents summarized (combine all red parts of the same size and have a "count" in the new table, for example) and cleared each week but stored first in another table that can be queried for a monthly (or larger) report. The original table needs to empty each time but what if the power to the PC is off...and it misses a weekly save? Any samples out there of how to do this "save to another place, then clear" functioality. Hope this makes sense. Many thanks!!!!