Duplicar campos de tabla

[GeriReshef]

Intenta así:

Código SQL:

INSERT  INTO T_CONT_RV
SELECT  ROW_NUMBER() OVER(ORDER BY cont_rv_c_iid)+Mx,
        cont_vig_c_iid,
        cont_ex_c_iid,
        cont_rv_c_eporc_x_rf,
        cont_rv_c_ctipo,
        cont_c_icod,
        cont_c_yver+1,
        cont_c_ymod
FROM    (SELECT MAX(cont_rv_c_iid) OVER() Mx,
                *
        FROM    T_CONT_RV) T
WHERE   cont_c_icod=@cont_c_icod 
        AND cont_c_yver=@cont_c_yver 
        AND cont_c_ymod=@cont_c_ymod;
 

Supongo que utilizas la versión 2005 o superior.