Great, its good to hear things worked out.

Good Luck. Let me know how it pans out.

Yes, you need to make the distinction between legacy and current data the current data. The current data would need to go into the new database and possibly +- 1hour...

There may the possibility of making a copy of the database and exporting the data out of your current database that you require for your application. You would need to...

UPDATE SS.SECTIONS WITH(ROWLOCK,HOLDLOCK) SET SECTNO=101 WHERE ROOMNO=601

This will indicate to the SQL engine that it must hold the lock on the rows it is updating till it has completed that...