If you want to backup table entries into a second table and delete them in the master table, you can use the folling SQL:
DELETE FROM masterTable
OUTPUT DELETED.* INTO archiveTable
FROM deletionTable
WHERE masterTable.ID=deletionTable.ID
while deletionTable contains the IDs of the entries, which should be deleted.
When using this, all entries of the masterTable, which are joined to the IDs in the deletionTable are copied to the archiveTable and then deleted.
Thanks, Ronny!
