title: Ignoring duplicate keys on Insert in SQL Server
body: <p>I have a table called <code>CustomerMemo</code>:</p>
  
  <p>CustomerMemo</p>
  
  <pre><code>CustomerID
  MemoID
  </code></pre>
  
  <p>Both of these are foreign keys. The columns are not unique because there could be something like this:</p>
  
  <pre><code>CustomerID    MemoID
  -----------   -------
  1             1
  1             2
  1             3
  </code></pre>
  
  <p>However, what I want to avoid is something like this:</p>
  
  <pre><code>CustomerID    MemoID
  -----------   -------
  1             1
  1             1
  </code></pre>
  
  <p>Anyone have a clue how to do this in SQL Server?</p>