SQL Update with row_number()
One more option
UPDATE xSET x.CODE_DEST = x.New_CODE_DESTFROM ( SELECT CODE_DEST, ROW_NUMBER() OVER (ORDER BY [RS_NOM]) AS New_CODE_DEST FROM DESTINATAIRE_TEMP ) x
DECLARE @id INT SET @id = 0 UPDATE DESTINATAIRE_TEMPSET @id = CODE_DEST = @id + 1 GO try this
With UpdateData As(SELECT RS_NOM,ROW_NUMBER() OVER (ORDER BY [RS_NOM] DESC) AS RNFROM DESTINATAIRE_TEMP)UPDATE DESTINATAIRE_TEMP SET CODE_DEST = RNFROM DESTINATAIRE_TEMPINNER JOIN UpdateData ON DESTINATAIRE_TEMP.RS_NOM = UpdateData.RS_NOM