Please help to extract xml.

• panneermca35

  Mr or Mrs. 500

  Points: 504

  More actions

  March 7, 2016 at 4:48 am

  #325351

  Hi,

  I have a following xml.

  '<Item>

  <Item customerid="101" customername="Ram" gender="Male" married="Y"/>

  <Item customerid="102" customername="Sham" gender="Male" married="Y"/>

  <Item customerid="103" customername="Tom" gender="Male" married="N"/>

  </Item>'

  I want the Result set like below.

  customerid customername gender Married

  101 ram Male Y

  102 sham Male Y

  103 tom Male N

  Dynamically the columns should come. every time xml will be change the values so dynamic query is well.

• drew.allen

  SSC Guru

  Points: 76949

  More actions

  March 7, 2016 at 11:23 am

  #1863526

  Please don't cross post. It fragments the thread. Please continue on this thread.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA