#For-Xml-Explicit

Using FOR XML EXPLICIT

FOR XML EXPLICIT lets a query define XML nesting and column treatment through Tag and Parent metadata columns, plus directives such as hide, element, xml, and cdata.