Getting data from XML using OPENXML

• Jonathan Mallia

  SSCertifiable

  Points: 5192

  More actions

  October 29, 2007 at 7:06 am

  #178810

  Hi Guys,

  I have the XML file (shown below) and i want to extract the category information.. I want to extract both the elements and the attributes...

  Can someone help me in this please?

  Thanks in advance!

  Jonimatix

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  October 29, 2007 at 8:03 am

  #746256

  This is posted and hopefully answered on http://www.sqlservercentral.com/Forums/Topic416002-145-1.aspx.

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software