Thanks a lot.

XLOCK is exactly what was needed in this case. It does block the thread that tries to read the row selected by other thread with XLOCK. So, in...

Now it is working correctly, but not the way you or I were expecting. It does not block the thread. It simply throws a deadlock exception on one of the...

Thank you for your response.

I see the problem in ability to use a dirty read. What I mean is this: The stored procedure makes a read and than based on...