title: insert into select not exists sql server multiple columns primary key voilation
body: <p>I have a table tblApply which have primary key(email_id, Job_id) which are foreign key of tblEmail(email) and tblJob(Job_id). I want to insert new values in tblApply but avoid those which are already there in a combination of email_id, Job_id. Below is my code. How should i do it. I am doing this inside a stored procedure.</p>
  
  <pre><code>insert into tblApply(email_Id, Job_Id, Apply_Date)
      select @emailId, tblJobsJob_Id, GetDate() from tblJobs
      where Job_Active = 1
  </code></pre>