title: how to select CSVs into rows along with another column in sqlserver
body: <p>I have something like the following data in a table:</p>
  
  <pre><code>id    str
  --    --------------------
   1    123,456,234
   2    17,54,22
   3    4,7
   4    432
   5    1,82,2
  </code></pre>
  
  <p>I want a SELECT statement that will give me the id and the str value seperated.  For example I want the following output from the sample above:</p>
  
  <pre><code>id     str
  --     ----------
   1     123
   1     456
   1     234
   2     17
   2     54
  
  etc
  </code></pre>
  
  <p>How do I get this result in sqlserver 2008?</p>