I have a multi-user application that requires a table-level lock
during an update so no users can write to the table during the update.
(All records are written out to a temp table, the records in the main table are then deleted, the records are sorted in the temp table, and the sorted records...