In case you are still wondering about this, you can use the "WITH XMLNAMESPACES" clause immediately prior to the SELECT clause, and you can add as many namespaces as you...

The method shown in this article is great if you like having everything in your XML set up as an attribute. If you prefer actual XML elements with values between...

Thanks. Haven't tried ExecuteXMLReader. I'll give it a shot. I did discover what you referred to - the XML is chopped up and placed into subsequent rows,...