These could of course also use UPDATE FROM syntax rather than a CTE ...
```
UPDATE tnTEST
SET fnrownum = rcn
FROM (
select fnidx as rci,
row_number() over (partition by 1 order by fnidx) as rcn
from tnTEST
)
WHERE rci == fnidx
;
```