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

---

]]>