select Table from xml

If we are using XML Data type then we often need to get table from XML. We will see here how to get table from XML data type. Lets take the XML with attribute and child tags in a variable @UsersDetail



So we saw how easy to get data in a table format from XML, just need to use
'@attributename' to get attribute value
'childtagname[1]' to get value of tag

Now what if there is a root tag suppose users?
We just need to pass path of tag we are trying to get the value of means user, have a look here