title: How to get parent element name using OpenXML in sqlserver
body: <p>If I have some xml:</p>
  
  <pre><code>&lt;Users&gt;
      &lt;User&gt;
          &lt;property1&gt;sdfd&lt;/property1&gt;
          ...
      &lt;User&gt;
      ... 
  &lt;/Users&gt;
  </code></pre>
  
  <p>And my sql is:</p>
  
  <pre><code>SELECT 
      *
  FROM
      OpenXML(@idoc, '/Users/User')
      WITH (  
            [property1] varchar(50) 'property1',
            ...
      )
  </code></pre>
  
  <p>How can I get the name of the parent element and return that in the dataset?</p>