title: Split comma separated string table row into separate rows using TSQL
body: <p>Say I have a query that returns the following</p>
  
  <pre><code>ID       SomeValue
  1        a,b,c,d
  2        e,f,g
  </code></pre>
  
  <p>Id like to return this as follows:</p>
  
  <pre><code>ID       SomeValue
  1        a
  1        b
  1        c
  1        d
  2        e
  2        f
  2        g
  </code></pre>
  
  <p>I already have a UDF calls Split that will accept a string and a delimter and return it as a table with a single column called [Value]. Given this, How shoudl the SQL look to achieve this?</p>