ALTER TABLE dbo.ManifiestosRem ADD CONSTRAINT
	FK_ManifiestosRem_Remesas FOREIGN KEY
	(
	RemNroRemEmpresa
	) REFERENCES dbo.Remesas
	(
	RemNroRemEmpresa
	) ON UPDATE  CASCADE 
	 ON DELETE  NO ACTION 
GO	
update Remesas set RemNroRemEmpresa =RemNroRemEmpresa + '-01' 
where (RemNroRemEmpresa not like '%-%' and estadoreg<>1) or 
(RemNroRemEmpresa not like '%-%' and RemNroRemEmpresa not in (SELECT RemNroRemEmpresa FROM  CumplidosRem))
