Динамическая нумерация строк в запросе

UPDATE hm
  SET hm.C_ParentElementTypeName_IS = 'Квартира',
   hm.C_ParentElementNumber_IS = hm.C_ElementNumber_IS,
   hm.C_ElementTypeName_IS = 'Комната',
   hm.C_ElementNumber_IS = ROW_NUMBER() OVER (ORDER BY hm.C_ElementNumber_IS)
  FROM GIS_GKH.CS_HouseMatchElements hm           
   INNER JOIN GIS_GKH.CS_HouseMatchElements t
    ON hm.F_HouseMatch = t.F_HouseMatch
  WHERE hm.C_ElementTypeName_IS = 'Квартира'
   AND hm.C_ElementTypeName_IS = t.C_ElementTypeName_IS
   AND hm.C_ElementNumber_IS = t.C_ElementNumber_IS
   AND hm.N_ElementSquare_IS != t.N_ElementSquare_IS
   AND hm.C_ElementTypeName_GIS IS NULL

with cte as
(
  select
   hm.C_ParentElementTypeName_IS,
   hm.C_ParentElementNumber_IS,
   hm.C_ElementNumber_IS,
   hm.C_ElementTypeName_IS,
   ROW_NUMBER() OVER (ORDER BY hm.C_ElementNumber_IS) as rn
  FROM GIS_GKH.CS_HouseMatchElements hm           
   INNER JOIN GIS_GKH.CS_HouseMatchElements t
    ON hm.F_HouseMatch = t.F_HouseMatch
  WHERE hm.C_ElementTypeName_IS = 'Квартира'
   AND hm.C_ElementTypeName_IS = t.C_ElementTypeName_IS
   AND hm.C_ElementNumber_IS = t.C_ElementNumber_IS
   AND hm.N_ElementSquare_IS != t.N_ElementSquare_IS
   AND hm.C_ElementTypeName_GIS IS NULL
)
UPDATE cte
  SET C_ParentElementTypeName_IS = 'Квартира',
   C_ParentElementNumber_IS = C_ElementNumber_IS,
   C_ElementTypeName_IS = 'Комната',
   C_ElementNumber_IS = rn;