Trouble extracting xml data when it has different namespaces? Get link Facebook X Pinterest Email Other Apps October 11, 2012 Ignore namespaces! "select @xmlDoc.query('data(/*:authors/*:child/*:id)') as UserID" from blog post http://maxbarrass.blogspot.se/2008/02/sql-2005-xml-xquery-ignore-namespaces.html Read more