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]