Insert into where no exist

INSERT INTO dbo.miscDemographics_Relation(miscDemographics_Id,miscDemographics_MasterId,miscDemographics_CreatedDate)

SELECT i.miscDemographics_ID,i.miscDemographics_MasterId,GETDATE() FROM inserted i

–END
WHERE NOT EXISTS (SELECT *
FROM dbo.miscDemographics_Relation mrl
WHERE i.miscDemographics_ID=mrl.miscDemographics_ID
AND ISNULL(i.miscDemographics_MasterId,0)=ISNULL(mrl.miscDemographics_MasterId,0))

You Might Also Like

Leave a Reply