Hi Michael,

Then how is the nnid returned to the user?

Glenn (SQLServewr newbie)

>There's a cleaner way. You can use UPDATE to increment and fetch the value without have to explicitly manage the locks:
>
>UPDATE id
>SET @nnid = idval, idval = idval + 1
>WHERE keyname = @tcKeyWord
>
>-Mike