As the AccountNumber table is to be treated as a Counter Table we can not forget to test if the record corresponding to the where clause exists!

If not then we...

I will keep your advise in mind when we migrate from SQL2005 to SQL2008.

For now I changed the UPDLOCK hint to TABLOCKX and this seems to be doing it!

Thanks to...

I'll try different cases to see if the one line statement could replace the initial statement.

Thanks voor the tip!

I added UPDLOCK to assure to hold the value for other not to update will within the transaction.

As I mentioned before, the SP worked perfectly on SQL2000 in a very...