SELECT CAUSESID, ROW_NUMBER() OVER (ORDER BY CausesID) as 'Row Number'
FROM Causes