pulling records

[lah3233]

We are trying to pull a record out of a table based on the number it is in result set. There is no actual number assigned to the row in the table. It somehow needs to be numbered after the query is pulled...without storing the number in the database. Does anyone out there have a way to solve this issue??

 

[sunila7]

Hi,


Can u give the sample data, how it is to be ordered and how u want to show the rownumber. have a look at this SQL it will put a Serial no for each row returned from authors table in pubs DB

select (SELECT Count(au_id)+1 from authors a1 where a1.au_lname<a.au_lname) Rownumber
,au_id,au_lname,au_fname from authors a
order by au_lname asc

Hope it helps

Sunil

Sunil

 

[lah3233]

Is there a property in SQL Server that gives you the row numbers so you don't have to use a count in the select statement?

 

[sunila7]

Hi,

There is no function in SQL Server that will return the row number

Sunil