SQL Update with row_number()

by

One more option

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

More Related Contents:

  1. Update a table using JOIN in SQL Server?
  2. Create a view with ORDER BY clause
  3. How to run the same query on all the databases on an instance?
  4. How to write UTF-8 characters using bulk insert in SQL Server?
  5. Is a single SQL Server statement atomic and consistent?
  6. Connecting to MS SQL Server with Windows Authentication using Python?
  7. determining the character set of a table / database?
  8. How to query for Xml values and attributes from table in SQL Server?
  9. A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
  10. Should every User Table have a Clustered Index?
  11. cross apply xml query performs exponentially worse as xml document grows
  12. How to split a string after specific character in SQL Server and update this value to specific column
  13. SQL Server Configuration Manager cannot be found
  14. Compute MD5 hash of a UTF8 string
  15. Sql Server replication requires the actual server name to make a connection to the server
  16. Convert a string with ‘YYYYMMDDHHMMSS’ format to datetime
  17. Convert from DateTime to INT
  18. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  19. SQL Server 2008 Spatial: find a point in polygon
  20. What do Clustered and Non-Clustered index actually mean?
  21. Regex pattern inside SQL Replace function?
  22. How can I clear the SQL Server query cache?
  23. WHERE Clause vs ON when using JOIN
  24. What is a free tool to compare two SQL Server Databases? [closed]
  25. #DELETE viewing SQL Server table in Access
  26. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  27. SQL Server (localdb)\v11.0 explained
  28. SQL Server equivalent to Oracle’s CREATE OR REPLACE VIEW
  29. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  30. Oracle sequence but then in MS SQL Server

Leave a Comment