Home Forums SQL Server 2008 T-SQL (SS2K8) How to add item No. in SELECT RE: How to add item No. in SELECT

  • March 7, 2013 at 10:45 am

    #1594588

    Does this do what you are looking for?

    SELECT C_NAME, ROW_NUMBER() OVER(PARTITION BY C_NAME ORDER BY C_NAME ASC) AS ITEM_NO, REQ_ITEM FROM @test1