I've to read attributes out of XML-Messages that use different namespace (-versions). From other documents and discussions I learned that wildcards can be used in namespaces within e.g. XMLTABLE. But all ways I tried to transform the solution into XMLQUERY do not work.
In the attachement I added the screenshot of the select statement that currently uses two XMLQUERY one for each namespace and returnting the values in different columns. The idea is to have just one XMLQUERY item that is able to find the attribute in all namespaces.
Any help would be highly appreciated.
Thanks and regards, Christian