SQL Server Performance

Row Numbers

Discussion in 'SQL Server 2005 Reporting Services' started by jastone, Jun 30, 2006.

  1. jastone New Member

    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
  2. merrillaldrich New Member

    Rownumber() function?


  3. ranjitjain New Member

    considerr this example:

    SELECT ROW_NUMBER() OVER (ORDER BY Col1ID ASC) AS ROWID, * FROM Table1

Share This Page