Shredding XML to a table

• antonela

  Ten Centuries

  Points: 1007

  More actions

  November 30, 2015 at 2:26 am

  #150422

  I have this XML file and I want to put it into a sql server table.

  <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

  <message xmlns="http://www.bankitalia.it/bolina/common/vo/message" xmlns:ns2="http://www.bankitalia.it/bolina/common/vo/cube"><header><survey>AT2</survey><partner>E01000</partner><initialDate>2015-06-30</initialDate><timeProduction>2015-11-23 12:25:05</timeProduction><type>SUBSTITUTION</type></header><content><dataSegment id="OBSERVATION"><cube xmlns="http://www.bankitalia.it/bolina/common/vo/cube" id="AT2_C0010100" lastObsId="0"><obs id="0"><dim name="ENTE_SEGN" value="E01000"/><dim name="DATA_CONTABILE" value="20150630"/><dim name="COD_FONDO" value="1000"/><dim name="COD_SEZIONE" value="100001"/><dim name="COD_COMPARTO" value="10000101"/><dim name="VOCESOTVOCE" value="C0010100"/><dim name="MISURA" value="-872"/></obs></cube><cube xmlns="http://www.bankitalia.it/bolina/common/vo/cube" id="AT2_C0015300" lastObsId="0"><obs id="0"><dim name="ENTE_SEGN" value="E01000"/><dim name="DATA_CONTABILE" value="20150630"/><dim name="COD_FONDO" value="1000"/><dim name="COD_SEZIONE" value="100001"/><dim name="COD_COMPARTO" value="10000103"/><dim name="COD_MANDATO" value="10000103001"/><dim name="VOCESOTVOCE" value="C0015300"/><dim name="MISURA" value="4415"/></obs></cube></dataSegment></content></message>

  I need to shredd to a table with these columns: ENTE_SEGN, DATA_CONTABILE,COD_FONDO,COD_SEZIONE, COD_COMPARTO,VOCESOTVOCE,MISURA (there are 2 records in this example).

  Anybody could help me? Thanks