Home Forums SQL Server 2008 T-SQL (SS2K8) How to add item No. in SELECT RE: How to add item No. in SELECT
RZ52
Mr or Mrs. 500
Points: 536
More actions
March 7, 2013 at 10:57 am
#1594597
Deque (3/7/2013)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
Deque (3/7/2013)
SELECT C_NAME, ROW_NUMBER() OVER(PARTITION BY C_NAME ORDER BY C_NAME ASC) AS ITEM_NO, REQ_ITEM FROM @test1
Yep, It worked.
Thanks Deque