Lynn Pettis (6/21/2012)

---

Assuming that you are doing this update in a stored procedure, I would do something more along the lines of this psudo code:

... prep work

set transaction isolation level serializable;

begin transaction

begin try

truncate destination_table;

insert into destination_table;

commit transaction

end try

begin catch

rollback transaction

... other error code as needed

end catch

end -- end of update procedure.