GitHub

for-xml-query-compared-to-nested-for-xml-query.md

Learn about the benefits of nested FOR XML queries by viewing an example that compares a single-level FOR XML query to a nested FOR XML query.
GitHub

shape-xml-with-nested-for-xml-queries.md

View an example of using nested FOR XML queries to shape the resulting XML. The two inner SELECT statements construct two <Price> elements, each with a PriceType attribute and XML that returns the ...