Dennis Post (9/4/2013)
What's the best way to store the XML?
An XML data type
http://msdn.microsoft.com/en-us/library/ms187339%28v=sql.120%29.aspx
The XML parameter used is already a XML data type.
To use the XML with other tables and use it's data it has to be converted to a table, with the nodes() statement or the sp_xml_preparedocument SP. Since it's used more than once it has to stored in a table to be faster.
It's the type of table that I'm questioning about...