Some more information on that -

I get -

LCK_M_S on the following:

Waiting on statement:

IF

(

SELECT TOP 1 1

FROM dbo.VersionTable WHERE StatusCd = 'New'

)

LCK_M_U on the following:

"/* (inserted by Ignite)

Character Range: 739 to 893

Waiting on statement:

UPDATE MME.[VersionTable]

SET [StatusCd] = 'Success' ,

UpdateDttm = GETUTCDATE()

WHERE VersionId = @VersionId

*/