You're correct it should insert only 1 record ! I forgot to add the top 1 in the example but it is included in the sql script.

GilaMonster (8/24/2009)

jan.tilburgh (8/24/2009)

insert into...

Okay I'll try again 🙂

So starting off with an empty test table and executing the procedure for the first time will result in the following row being inserted in the...

Okay ... here is the sample data :

The following is a sample of what we get when the procedure is ran from 2 different locations at the same time :

testID...