I started out writing something to the effect of it being mighty difficult but I thought I'd try the simple approach. The problem is, of course, what happens when they...
You'd then need to insert the results from the view (in the order you need) into a temporary table or a table variable that has an identity column, and then...