title: T-SQL: Where xxx IN temporary table
body: <p>I have a temp table and want to check in a where clause wether a certain id/string is contained in the temp table.</p>
  
  <pre><code>Select...
  WHERE MyId  IN MyTempTable
  </code></pre>
  
  <p>I get a general error in MS SQL Management studio.</p>
  
  <p>is the "In" operator not suited for temp tables?</p>