title: Concatenate XML without type casting to string
body: <p>I have the following XML generated from various tables in my SQL SERVER database</p>
  
  <pre><code>&lt;XMLData&gt;
  ...
  &lt;Type&gt;1&lt;/Type&gt;
  ...
  &lt;/XMLData&gt;
  </code></pre>
  
  <p>AND</p>
  
  <pre><code>&lt;XMLData&gt;
  ...
  &lt;Type&gt;2&lt;/Type&gt;
  ...
  &lt;/XMLData&gt;
  </code></pre>
  
  <p>AND</p>
  
  <pre><code>&lt;XMLData&gt;
  ...
  &lt;Type&gt;3&lt;/Type&gt;
  ...
  &lt;/XMLData&gt;
  </code></pre>
  
  <p>The final output I need is single combined as follows:</p>
  
  <pre><code>&lt;AllMyData&gt;
      &lt;XMLData&gt;
          ...
          &lt;Type&gt;1&lt;/Type&gt;
          ...
      &lt;/XMLData&gt;
      &lt;XMLData&gt;
          ...
          &lt;Type&gt;2&lt;/Type&gt;
          ...
      &lt;/XMLData&gt;
      &lt;XMLData&gt;
          ...
          &lt;Type&gt;3&lt;/Type&gt;
          ...
      &lt;/XMLData&gt;
  &lt;AllMyData&gt;
  </code></pre>
  
  <p><strong>NOTE - all the independent elements that I am combining have the same tag name.</strong></p>
  
  <p>Thanks in advance for looking this up.</p>