Problem with Identiy Sort Query

[DotNetBlocks]

Hello,
How can i add an identity colum to a query so that it will be related to the sort order?

Example:

select * from tempTable order by feild1 desc, feild1

 

[ptheriault]

Check out this thread. SQLDenis added some great stuff.

thread183-1306393

- Paul
- If at first you don't succeed, find out if the loser gets anything.