title: SQL to XML - delimited string to separate tage
body: <p>I'm trying to output DB table as XML with SQL FOR XML.
  Column A contains a comma separated string "value1, value2". I would like to output this string as two rows, where ns1 is a defined namespace.</p>
  
  <pre><code>&lt;ns1:root&gt;
  &lt;ns1:tag&gt;value1&lt;/ns1:tag&gt;
  &lt;ns1:tag&gt;value2&lt;/ns1:tag&gt;
  &lt;/ns1:root&gt;
  </code></pre>
  
  <p>What would be the correct SQL syntax?</p>
  
  <p>Thanks for help</p>