Geoff A (1/3/2011)
This is great info. Thanks Wayne.what do you think about making ALL x.data.values to be VARCHAR in the event that the XML is not well formatted?
For a standard way of doing things, I would not be in favour of doing that. Plus, it's not really XML if it's not well-formed, is it?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes