November 29th, 2001, 04:47 AM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
Numbering a query in SQL Server
Originally posted by : Carlo (raffic@tin.it)Hi,I've to number the records in a SQL query made with SQL Server 2000. I need a field containing the number of that specific row starting from 1 and ending with the number of records retrieved.Example1, Field1, Field2, Field2....., FieldN2, Field1, Field2, Field2....., FieldN3, Field1, Field2, Field2....., FieldN.....N, Field1, Field2, Field2....., FieldNWhere the first field will contain the row number.Can someone help me?Thanks
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
