title: How to extract list of values into rows from XML using XQuery?
body: <p>I have an XQuery as under</p>
  
  <pre><code>DECLARE @x XML
  SELECT @x = '&lt;PartnerEmails&gt;
  &lt;Email&gt;a@xxxx.com&lt;/Email&gt;
  &lt;Email&gt;b@xxxx.com&lt;/Email&gt;
  &lt;/PartnerEmails&gt;'
  SELECT @x.query('data(PartnerEmails/Email)').value('.','varchar(100)') AS Val
  </code></pre>
  
  <p><strong>Actual Output:</strong></p>
  
  <pre><code>Val
  a@xxxx.com b@xxxx.com
  </code></pre>
  
  <p><strong>Expected Output</strong></p>
  
  <pre><code>a@xxxx.com
  b@xxxx.com
  </code></pre>
  
  <p>i.e. In two different rows.</p>
  
  <p>How to do so?</p>