Hi Koustav, you could indeed have the solution you suggest, but I am not sure what the relative benefits would be. In this sort of unique situation, I would honestly...
The current method we use is of course using a # temp table with an Identity column added with an ORDER BY clause. (The only(?) time one should use an...