title: How would I create a temp table in SQL Server when I have a big list of ID's
body: <p>I have a list of raw IDs that I am supposed to put into a temp table. I am unsure about how this works in SQL Server: </p>
  
  <p>I know the general format:</p>
  
  <pre><code>select PID into #myPIDs
  from ... ?
  </code></pre>
  
  <p>I already have a list of about 30 PIDs which I am to use. They look like so:</p>
  
  <pre><code>'U388279963',
  'U388631403',
  'U389925814'
  </code></pre>
  
  <p>How do I go about doing this? Thanks!</p>