Batch replicate

[crash]

I have a table with 500 records... each month I need to edit this same records, but save the previous month.

Are there any suggestion on how I could duplicate and reset all the records in one batch.
I understand the table will grow by 500 each month.

Thanks

[Webmaster]

For batch insert, you can use "SELECT ... INTO ..." SQL statement. To run the SQL in server events, use the Execute function.

Please google for "SELECT INTO" to see the correct syntax.