SELECT Customer_Number, phone1,phone2,
row_number() over(order by Customer_Number) [rowNum]
FROM Sample_UnPivot_Table
-----end-----
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-----
SELECT Customer_Number, phone1,phone2,
row_number() over(order by Customer_Number) [rowNum]
FROM Sample_UnPivot_Table
-----end-----