--SET REC ID TO CORRISPETIVE REPORTO TO MIG

update db_PalPortalServices.dbo.ReportTemplate
set Report = (select Report from db_PalPortalServices_DEV.dbo.ReportTemplate where RecId = 0)
where RecId = 0