se debe analizar el resultado de los select y verificar los registros duplicados


select * from act_cna07
select * from act_cna12
select * from act_cna02

select * from ant_cna07
select * from ant_cna12
select * from ant_cna03_1

Si act_cna12 y ant_cna12 tienen duplicados:
delete act_cna12 where id_act_cna12 in (select max(id_act_cna12) from act_cna12 )
delete ant_cna12 where id_ant_cna12 in (select max(id_ant_cna12) from ant_cna12 )

Si act_cna07, act_cna12, ant_cna07,ant_cna12 tienen duplicados:

delete act_cna07 where  DATEPART(year, primer_fec) not in (select DATEPART(year, fecha_as) from act_cna02)
delete act_cna12 where id_act_cna12 not in(select id_act_cna07 from act_cna07)
delete ant_cna07 where DATEPART(year, primer_fec) not in (select DATEPART(year, fecha_as) from ant_cna03_1)
delete ant_cna12 where id_ant_cna12 not in(select id_ant_cna07 from ant_cna07)