title: Unpivot the columns into rows
body: <p>I have one row with an unknown number of columns. I need to unpivot all those columns into one column. Here is an example. I start with this table </p>
  
  <pre><code>select 1 as c1, 2 as c2, 3 as c3
  into tempP
  </code></pre>
  
  <p>If we select this table the result will be</p>
  
  <pre><code>c1  c2  c3
  1   2   3
  </code></pre>
  
  <p>I want the result to be this</p>
  
  <pre><code>new_name
  1
  2
  3
  </code></pre>
  
  <p>Also, remember that I don't know if I will have 3 columns. I might have 100 columns, but the number of rows will always be 1. Thanks.</p>