Convert xml file into sql table

• Mareeya

  SSC Enthusiast

  Points: 175

  More actions

  January 10, 2014 at 5:10 am

  #302624

  This xml file have to be converted into table format which is shown below.The 3rd column mentioned in the table have to be extracted based on maleworker and femaleworker tabs.

  <?xml version="1.0"?>

  <ROOt>

  <Document Type="workersinput" Version="1.0.0" />

  <Manager Name = "Robby">

  <workers>

  <Maleworker Value = "Antony">

  <Femaleworker Value = "Fileebarta"/>

  </Maleworker>

  </workers>

  </Manager>

  <Manager Name = "Walton">

  <workers>

  <Maleworker Value = "Jhony">

  <Femaleworke Value = "jennifer"/>

  </Maleworker>

  </workers>

  </Manager>

  </Root>

  Output table :

  Managerworkerssex

  RobbyAntonyM

  RobbyFileebartaF

  WaltonJhony M

  WaltonjenniferF

  Please let me know if anyone knows the answer for this.

  Thanks in advance.

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  January 10, 2014 at 5:44 am

  #1679111

  Import the XML into a staging table, then the <XMLColumn>.value function to shred it into the individual columns.

  John