Cacher is the code snippet organizer for pro developers

UPDATE hecustomers
SET hecode = a.newcode
FROM (SELECT
  heid,
  concat(LEFT(hecode, 5), RIGHT(concat('00000000', ROW_NUMBER() OVER (ORDER BY hecode)), 8)) AS newcode
FROM hecustomers) AS a
INNER JOIN hecustomers
  ON hecustomers.heid = a.heid

UPDATE hesuppliers
SET hecode = a.newcode
FROM (SELECT
  heid,
  concat(LEFT(hecode, 5), RIGHT(concat('00000000', ROW_NUMBER() OVER (ORDER BY hecode)), 8)) AS newcode
FROM hesuppliers) AS a
INNER JOIN hesuppliers
  ON hesuppliers.heid = a.heid