>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?
Check ROW_NUMBER() function in BOL.
If it's not broken, fix it until it is.
My Blog