Hi,
Using either HOLDLOCK or UPDLOCK as a lock hint allows other transactions to see the data, but, when used together, the other transactions cannot see the data until the previous transaction is completed.
Can anyone shed some light on what happens when these locks are used together, and what happens.
Thanks.