Row_number() in SQL 2000 ...

  • I'll have to disagree here FP.  I think the problem is solved.  Just as Jeff said (and I said in my first post), an IDENTITY column will be required for this to work.  You may not have one already, but you can surely read your rows into a temporary structure that does.  At that point, pick a solution as there is more than one solution here that will work for you.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • Okay. I'll try that and get back to you guys. Thanks for all of you participated.


    FP

    True Love is Like A Ghost. Everyone Talks About It & Nobody have seen it.

  • FP (8/8/2007)


    Okay. I'll try that and get back to you guys. Thanks for all of you participated.

    True Love is Like A Ghost. Everyone Talks About It & Nobody have seen it.

    Funny how your tag-line rang true here... you never did get back to us like you promised, FP... Must be the "true love" you spoke of, eh? 😛

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Its takes one to spot one 😀 ... i have been busy in migration 2000 to 2005 with dts and one particular BI project, but this should not be taken as an excuse. Well who i am kidding ... its the only excuse i can put forward 🙂 I'll try not to be "true love" anymore.

  • FP = Farrukh? You got two logins?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • A keen observation you have Jeff, I'll give you that 🙂 Yes I am in the middle of this identity crisis.

    Thanks

    FP = Farrukh

  • Heh... another keen observation is that you still haven't told us how things worked out. 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply