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

   jastone, Jun 30, 2006

   #2
2. merrillaldrich New Member

   Rownumber() function?
   
   
   

   merrillaldrich, Jun 30, 2006

   #2
3. ranjitjain New Member

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

   ranjitjain, Jul 1, 2006

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in