Determining row numbers in recordset

Question

Determining row numbers in recordset

Sherif Maamoun

Ten Centuries

Points: 1254
More actions
August 18, 2005 at 6:00 am

#165685

I need to show the row number for recordsets in functions, procedures, and views. This number will be used for formatting rows in user interface to show different colors for alternating rows

Viewing 5 posts - 1 through 4 (of 4 total)

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

Phil Parkin SSC Guru Points: 246985 More actions · Answer 1

So you want the first column of a returned recordset to be row number? Not straightforward via T-SQL (although I'll wait for someone here to prove me wrong!). I would expect this sort of thing to be done by the front end app.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

It can be done... but it's the job of the presentation layer.

Just declare a int and increment it in the while not MyRs.EOF() and format using that variable.

Ray M SSC-Insane Points: 21093 More actions · Answer 3

Err wait, Nevermind. Cant Read

Edit:

If you want to do something like this you are adding a ton of overhead onto the sql server. and if you allow client side sorting you are guaranteeing the need to hit sql server on each postback and it will make each procedure more complex because of the need for a "Dynamic" Order by.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Don't the recordset tools have order methods in 'em?? Why don't we use 'em?? .