Very useful article to understand the XML conversion options available in SQL. Concise examples are the key.

I agree with Jeff in his views around XML. Bloated and not that easy to interpret for a human being, but accomplished it's objective to become a common standard. The equivalent of IRS here use it to represent our invoices and record keeping.