You are always going to have locks of one type or another. I guess the real problem you're wanting to describe is that you're encountering blocks on your DML statements....

Simply get the IDs into a table variable, and then the problem is solved.

I encounter this scenario a lot with stored procedures, typically developed for reporting purposes, which accept a...

The last value inserted into your table was 'Snoopy'. Prove me wrong.

Seriously, without a date/time column, or at least a sequential identifier, there is no deterministic way to know...