Getting RowNumbers from a Table

Question

Getting RowNumbers from a Table

Viewing 2 posts - 1 through 3 (of 3 total)

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

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 1

Heh... and what form of age discrimination will this be used for? 😉

--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)

Jack Corbett SSC Guru Points: 184395 More actions · Answer 2

Are you really using SQL Server 7 or 2000?

I'd start with a simple query that returns the rows I want.

Select columns desired from table where age = 45 and posted_user_id = @posted_user_id

I'm not sure what you mean by row number because you haven't posted the table definiton, so I don't know if there is a column named rownumber or if you mean the primary key for each row.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question