title: Delete from table the records that are in #temp table
body: <p>I've created a #temp table in SQL containing duplicate records.</p>
  
  <p>I would like to remove from my primary table all of the records contained in this temp table. I see samples to do this but they seem to all invovle selects, and I already have my select in the temp table.</p>
  
  <p>Here's what it would look like in pseudocode:</p>
  
  <pre><code>DELETE FROM MyMainTable(unique and duplicate records) WHERE the record exists in #temp
  </code></pre>