Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    7

    Unanswered: Sorting 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

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: Sorting Cursor Output WITHOUT using Order By

    Originally posted by rajk
    Please let me know the different possibilities in this scenario.
    Raj
    Sure...

    http://www.dbforums.com/t985991.html

    And

    http://www.dbforums.com/t985972.html
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You see, the crapier the design, the more twisted coding you end up doing. Why don't you post the task, someone (who's as bored as I am, maybe a little more) will take a stab at it.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by rdjabarov
    who's as bored as I am
    Thanks...got a chuckle with that one....

    EDIT: (or is that just totally disinterested?)
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •