title: How to convert comma separated value into rows in sql server
body: <blockquote>
    <p>How can I convert comma separated value as :</p>
  </blockquote>
  
  <p><strong>Table</strong></p>
  
  <pre><code>User Name  Unit
  ABC        2,3  
  </code></pre>
  
  <p>to the following :</p>
  
  <pre><code>User Name  Unit
  ABC        2  
  ABC        3
  </code></pre>