I'm extracting rows from a table and ordering the result based on idcol, an identity column.
I want to add a column to the resultant set that shows what position the row holds in the set.. 1, 2, 3, etc.
How best to do that?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.