Using metaproperties in Ms Sql Server when xml processing in sql with OpenXml
In processing some XML into an SqlServer db it can often be useful to have the element name or the parent element name output, depending on how your xml data is organised. Below is an example of using meta properties in MS SQL Server for just this purpose.