I sometimes use this function if I find myself in a similar situation where I need to shred an xml structure to a tabular form but do not know the xml schema.
http://beyondrelational.com/modules/2/blogs/28/posts/10495/xquery-lab-58-select-from-xml.aspx