Mzsmunna
10/15/2019 - 2:20 PM

Update Set From

UPDATE         c
SET           c.OrganizationName = new.[Organization Name]
FROM          Enrollment_V1.dbo.CPSC_Contract_Info c
INNER JOIN    CMS_DB.dbo.CPSC_Contract_Info_2019_09 new
ON            c.ContractID = new.[Contract ID]
and c.PlanID = new.[Plan ID]
and c.OrganizationName != new.[Organization Name]

-------------

UPDATE         main
SET           main.ParentOrganization = new.[Parent Organization]
FROM          Enrollment_V1.dbo.CPSC_Contract_Info main
INNER JOIN    CMS_DB.dbo.CPSC_Contract_Info_2019_09 new
ON            main.ContractID = new.[Contract ID]
and main.PlanID = new.[Plan ID]
and main.ParentOrganization != new.[Parent Organization]