title: SSRS XML Data Source How do I query XML with multiple parent child hierarchy
body: <p>How do I query XML data source in SSRS so that two parent-child hierarchies are returned?
  For example</p>
  
  <pre><code>&lt;parent&gt;
      &lt;child1&gt;
          &lt;child2&gt;
              &lt;child3&gt;
                  &lt;a1&gt;1&lt;/a1&gt;
                  &lt;b1&gt;2&lt;/b1&gt;
              &lt;/child3&gt;
              &lt;child4&gt;
                  &lt;c1&gt;1&lt;/c1&gt;
                  &lt;d1&gt;2&lt;/d1&gt;
              &lt;/child4&gt;
          &lt;/child2&gt;
      &lt;/child1&gt;
  &lt;/parent&gt;
  </code></pre>
  
  <p>How do I query this XML so that I get a1,b1,c1,d1 as a result set?</p>