I have a SQL Server table with a column of type XML. The XML data represents multiple allowable selections for a given field. An example of the XML data is as follows. I am using the following code to extract the data from the XML column and transforming it into rows that can be inserted into a new table. This