Returning XML Column Data As a Set of Data from SQL

I needed to write something like this ... SELECT * FROM CustomerTest WHERE Customer_Id = 1; The data returned needed to return the row as well as the data inside of the XML Column in that row, in the same set. (The data in the XML column needed to be returned as sets of records as well.) The XML Contained was simple XML that looked like this...