Batch replicate

ASP.NET Maker General Discussion (ASP.NET Maker)
1

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

2

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.