Home Forums Programming XML Inserting data using OPENXML RE: Inserting data using OPENXML

  • June 21, 2017 at 5:10 am

    #1947517

    Eirikur Eiriksson - Wednesday, June 21, 2017 3:58 AM

    This looks like relatively simple XML, you should just use XQuery to parse it
    😎

    Something like this:
    SELECT
      REPORT.DATA.query('.')
    FROM @TXML.nodes('Reports/Report') AS REPORT(DATA)

    Thanks, Let me dig further from this solution.