Row numbers

[jamesd0142]

I have a basic query such as...

SELECT WBLTP_Payment
FROM DS_WBLTP_Payment
 

this shows data like..

<colunmname>
12
13
14
15

QUESTION:
How can i get row numbers also so my result looks like this...

<ID><colunmname>
1 12
2 13
3 14
4 15

[ck9663]

i don't think there's a record/row number that's automatically created in sql server. if you really need to, read this:


http://www.sqlteam.com/article/retur...ber-in-a-query


-- CK

[Jim Doherty]

I have a basic query such as...

SELECT WBLTP_Payment
FROM DS_WBLTP_Payment
 

this shows data like..

<colunmname>
12
13
14
15

QUESTION:
How can i get row numbers also so my result looks like this...

<ID><colunmname>
1 12
2 13
3 14
4 15

What version SQL Server are you using?

Jim

[jamesd0142]

im using SQL server 2000

[Jim Doherty]

im using SQL server 2000

OK just wondered because SQL Server 2005 took this on board with 'row_number over' it doesnt exist in 2000 so go with ck9663s post

Jim :)

[jamesd0142]

Yes, id appriciate some help if possible, tried for hours on this and still no good.

Thanks

for example:

table contains several columns

table: users

column names: fName, lName, Login, password