title: SQL Server: WHERE NOT EXISTS is not working
body: <p>I have a table <code>Main1</code> which have 21 records and temp table  <code>@recordsToDel</code> have 20 records. 
  20 Rows are identical in both tables but the following select query is not returning the missing record and delete is also not deleting it. Both table have similar columns.</p>
  
  <p>Any suggestions please?</p>
  
  <pre><code>SELECT * FROM dbo.Main1
  WHERE NOT EXISTS
  (
      SELECT * FROM @recordsToDel
  );
  
  DELETE FROM dbo.Main1
  WHERE NOT EXISTS
  (
      SELECT * FROM @recordsToDel
  );
  </code></pre>
  
  <p>Many Thanks</p>