Cari Blog Ini

25 April 2012

How to Create Row_Number() in Table

-----start-----
SELECT Customer_Number, phone1,phone2,
row_number() over(order by Customer_Number) [rowNum]
FROM Sample_UnPivot_Table
-----end-----