Great post. Here's how to dinamically create query to convert columns from XML. I used this in ServiceBroker app



DECLARE @XmlDocument XML;
SET @XmlDocument = (select TOP 1...