>>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.
Thanks, Naomi. I found the answer.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.