Mzsmunna
10/15/2019 - 2:16 PM

INSERT INTO FROM a Table --WHERE

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 )