Row Numbers | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Row Numbers

I want the rows in a report to have a number, rowcount(table1) doesnt work, is there something like that which would put row numbers as the first column?? thanks in advance Joe Janka
Rownumber() function?

considerr this example: SELECT ROW_NUMBER() OVER (ORDER BY Col1ID ASC) AS ROWID, * FROM Table1