SELECT CONSEQUENCEID, ROW_NUMBER() OVER (ORDER BY CONSEQUENCEID) as 'Row Number'
FROM Consequences