script to move records between tables

[olisemalis]

Hello,

I need a script to move some records from one table to another table (an history table). I need then to delete the moved records from the original table. Both tables are at the same databases. The fields are the same and the history table doesn´t have any keys defined. To define the records to move, I just need to specify a date to a datetime fields.

Certanly I will need to put this sql instruction in a begin/commit transaction.

Any help would be appreciate.

Thank you

 

[SQLSister]

So what do you have so far? What problem are you running into?

"NOTHING is more important in a database than integrity." ESquared

 

[djj55]

A simple INSERT and then a DELETE WHERE should work. Any code you have so far would be helpful in answering your question.
djj