INSERT INTO [Enrollment_V1].[dbo].[CPSC_Contract_Info]
([ContractID]
,[PlanID]
,[OrganizationType]
,[PlanType]
,[OffersPartD]
,[SNPPlan]
,[EGHP]
,[OrganizationName]
,[OrganizationMarketingName]
,[PlanName]
,[ParentOrganization]
,[ContractEffectiveDate])
SELECT TOP (1000) [Contract ID]
,[Plan ID]
,[Organization Type]
,[Plan Type]
,[Offers Part D]
,[SNP Plan]
,[EGHP]
,[Organization Name]
,[Organization Marketing Name]
,[Plan Name]
,[Parent Organization]
,[Contract Effective Date]
FROM [CMS_DB].[dbo].[CPSC_Contract_Info_2019_09]
WHERE [Contract ID] NOT IN (SELECT ContractID FROM Enrollment_V1.dbo.CPSC_Contract_Info )