Row_number() in SQL 2000 ...

Question

Row_number() in SQL 2000 ...

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

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

John Rowan SSC Guru Points: 56440 More actions · Answer 1

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

FP-401493 Say Hey Kid Points: 703 More actions · Answer 2

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.

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 3

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)
Intro to Tally Tables and Functions

Farrukh SSC Veteran Points: 294 More actions · Answer 4

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.

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 5

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)
Intro to Tally Tables and Functions

Farrukh SSC Veteran Points: 294 More actions · Answer 6

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

Thanks

FP = Farrukh

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 7

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)
Intro to Tally Tables and Functions