update_view_manual.sql

update Document set stat = 0 where id_documento in (
select id_documento from (
select 
		d.id_documento
from 
	DocumentOrigin o
inner join Document d on d.id_documento = o.id_documento
where 
	o.id_registro in(
		SELECT 
			o.id_registro
			
		FROM
			Document d
				INNER JOIN
			DocumentOrigin o ON o.id_documento = d.id_documento
		WHERE
			d.stat <> 0 and id_registro > 128263
		group by o.id_registro
		having Count(*) > 1
) and d.caminho_file is null) as view
);