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...