Numerator a column

Numerator a column by using row_numbers.

Last updated: 1 November 2016

Warning: Review and test in a non-production environment before running.

Back to results

UPDATE x

SET x.SIDRATI = x.NEW_SIDRATI

FROM (

SELECT SIDRATI,ROW_NUMBER() OVER (ORDER BY SIDRATI) AS NEW_SIDRATI

FROM TNUOT_MITZ_TSUA

) x;