Extracting Specific Elements from an XML Document using XQuery in SQL Server 2005 or Later

Understanding Dynamic XML Hierarchies in SQL Server Using XQuery FLWOR Expressions

Generating an XML Sitemap for Multiple Products Using XQuery and SQL