A better way is to use the nodes method

http://technet.microsoft.com/en-us/library/ms188282.aspx

A good article on this: Ad-Hoc XML File Querying by Seth Delconte

https://www.simple-talk.com/content/article.aspx?article=1756