Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007
    Posts
    24

    Unanswered: Get RecordNumber with output

    Hi everyone,

    How can get the record number as column with my query output.

    I dont want to insert the values in #temp table with IDENTITY function.


    Any other trick...




    Riyaz

  2. #2
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    You don't state which version of SQL Server you are using. If you are using SQL Server 2005 you can use the new ROW_NUMBER() function.
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

  3. #3
    Join Date
    Mar 2007
    Posts
    24
    Quote Originally Posted by roac
    You don't state which version of SQL Server you are using. If you are using SQL Server 2005 you can use the new ROW_NUMBER() function.

    Sorry for that

    I am using SQL Server 2000

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •