There could be a better way to do this without transactions or locking tables.

1) Make sure there is a datetime column in the destination table.

2) When inserting data, declare a...