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