
March 1st, 2004, 06:47 AM
|
|
Registered User
|
|
Join Date: Apr 2003
Posts: 20
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Sort Cursor Output without Using Order By
Hi,
I have a situation where I need to sort the output of a cursor. But since the sort criteria are rather complex, I am NOT able to use the Order By clause directly with the cursor definition statement.
Hence, I need to have a solution where I will use a dummy (calculated) field within the CURSOR and I want the output of this cursor sorted by the dummy field that I calculated within the cursor itself.
Please let me know the different possibilities in this scenario.
Thank you in advance
Raj
|