1 Reply Latest reply: Mar 26, 2012 9:55 AM by markevans RSS

    xml data handling with from_field

      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