title: Convert list of values in SQL to CTE or Temp Table
body: <p>How can I convert a list of values like (value1, value2, value3, ...., value500)
  to a temp table or cte? </p>
  
  <p>One way would be to do:</p>
  
  <pre><code>WITH huge_list_cte AS (
     Select value1
     UNION
     Select value2 ...
  )
  </code></pre>
  
  <p>Is there a better way?</p>