The Gray Zone

Today I was working with data stored using SQL Servers XML datatype. I had to find a way of dealing with the XML data like you would standard relational table data. Here’s how to do it. Sample table and data Firstly, here is a basic table to store the data: CREATE TABLE DummyTable ( DummyTableID [...]