UPDATE x
SET x.CODE_DEST = x.New_CODE_DEST
FROM (
SELECT CODE_DEST, ROW_NUMBER() OVER (ORDER BY [RS_NOM]) AS New_CODE_DEST
FROM DESTINATAIRE_TEMP
) x
Related posts:
Unique Constraints in MS SQL Server to prevent duplications
Get the User Name and Domain Name from an Email Address in SQL
Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql st...
Capitalize words in SQL (Display data first letter uppercase rest lowercase)
Get a Tree view with SQL Query