Your XML has a default namespace associated with it, so you will need to supply the default namespace to XMLTable/XQuery as well. Also the XPaths in the COLUMNS clause are relative to the XPath for the XMLTable itself, so I adjusted that as well. The below returns rows, but I did not verify it is what you desired. This should give you a start at least.