title: Convert SQL columns to rows
body: <p>I would like to split one records columns into multiple rows.</p>
  
  <p>If I have a SQL statement like the following:<br></p>
  
  <pre><code>SELECT 1,2,3
  </code></pre>
  
  <p>Result: </p>
  
  <pre><code>1 | 2 | 3
  </code></pre>
  
  <p>How do I convert that to the following result?</p>
  
  <pre><code>1
  2
  3
  </code></pre>
  
  <p>I am currently using MS SQL 2008.</p>