Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
The table I have to query has an XML-structure in one of the Attributes.
I can get the XML-Content using
Table1:
SELECT ID, Type, CAST(CAST(Content as VARBINARY(MAX)) as XML) as SubAttributes
How can I have the "Content" be further parsed to get the XML-information into a QV-Table? Read about the FROM_FIELD instruction but can not figure out proper syntax.
Inside_Data:
LOAD [Query/CommandText] as CommandText
?? FROM_FIELD SubAttributes -- does not work
Unfortunately did not get an answer to a similar question asked a few weeks ago.
Thanks, Juerg
I had a similar issue and had to use textbetween to get the info we wanted.
LOAD
TextBetween(Textbetween(SubAttributes, '<Query>','</Query>'),'<CommandText>','</CommandText>')
Mark