Right, I think I've found the issue.

As you can see from this SQLFiddle http://sqlfiddle.com/#!6/7801f/6 (watch out, sqlfiddle doesn't display the char that caused the issue for me in the first...

I accidently posted in the wrong area, I've now re-posted over here:

http://www.sqlservercentral.com/Forums/Topic1672918-23-1.aspx

Hi,

I would agree with Evil Kraig F when he states that you don't want the contacts or addresses belonging to multiple customers. Also when he states that you should...

@seregak76

Hiya,

I would be very interested to have a little more information such as, SQL server version and SP, number of concurrent connections (also how many uids would be requested simultaneously)...

Hiya Meg77,

You don't need to use sp_getapplock, the built in transactions work fine for the example you mentioned.

The following code is just one way to skin this cat...

declare @i_uid int

begin...

I found this an interesting discussion, particularly as this is something I've had to do a few times in the past.

We always try to keep the datetime as a datetime...

I have to say that my first reaction to reading this article was that it was complete overkill and that the solution should be to insert into the client table...

Your error handling is screwed.

The moment you run any code after the line the has an error @@error is reset, you can test this fact with the following:

select 1/0 as...