title: T-SQL -- convert comma-delimited column into multiple columns
body: <p>From the table below, how can I convert the <code>Values</code> column into multiple columns, populated with individual values that are currently separated by commas?  Before the conversion:</p>
  
  <pre><code>Name  Values 
  ----  ------
  John  val,val2,val3 
  Peter val5,val7,val9,val14 
  Lesli val8,val34,val36,val65,val71,val 
  Amy   val3,val5,val99
  </code></pre>
  
  <p>The result of the conversion should look like:</p>
  
  <pre><code>Name  Col1  Col2  Col3  Col4  Col5  Col6 
  ----  ----  ----  ----  ----  ----  ----
  John  val   val2  val3 
  Peter val5  val7  val9  val14 
  Lesli val8  val34 val36 val65 val71 val 
  Amy   val3  val5  val99
  </code></pre>