Juan carlos 2012-04-18 06:29:37
I will like to have, along with my quesry result, another
column that will store the number of the row, for example:
1 query results…
2 query results…
3 query results…
how can i do this?
Vishal parkar 2012-04-18 06:29:41
Refer to following url
HOW TO: Dynamically Number Rows in a Select Statement
if you have any unique field in the table then you can try a query something
select (select count(customerid) from customers where customerid <= a.customerid) rank, * from customers a go -- -Vishal
Aaron bertrand 2012-04-23 16:09:02
Aaron Bertrand, SQL Server MVP
Please reply in the newsgroups, but if you absolutely
must reply via e-mail, please take out the TRASH.