Microsoft SQL Server forum - Row sequence number

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Row sequence number

evandroc

2006-04-03, 8:26 pm

Hello all,

I=B4m currently using a SQL Serve 2K. Would like to do a select
which returns the row number - this should not be physically stored in
the database. So for example, I would like to do a query against the
CUSTOMER table and receive:

* rowID || name
1 Evander
2 Ron
3 Scoth
4 Jane

I don=B4t want to store the ID, because if I change the order by
clause, the sequence may modifiy, and, for another example, having the
same set of data, I would receive:

* rowID || name
1 Scoth
2 Ron
3 Jane
4 Evander
=20
could someone help me ?

best regards,
Evandro

Anith Sen

2006-04-03, 8:26 pm

http://support.microsoft.com/defaul...b;EN-US;q186133

--
Anith

Madhivanan

2006-04-04, 9:28 am

Use Front end application to number the result

Madhivanan

Sponsored Links