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
For better, quicker answers on T-SQL questions, read
Jeff Moden's suggestions.[/url]
"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort