UPDATE ger_servico s set srv_ordenacao = v.rn
FROM
(
    SELECT row_number() over (partition by sit_codigo order by srv_acessos) AS rn, srv_codigo
    FROM ger_servico
) AS v
WHERE s.srv_codigo = v.srv_codigo;

UPDATE ger_slide s set sli_ordenacao = v.rn
FROM
(
    SELECT row_number() over (partition by sit_codigo order by sli_codigo) AS rn, sli_codigo
    FROM ger_slide
) AS v
WHERE s.sli_codigo = v.sli_codigo;