Convert xml into table view......

• Jonathan Ely

  SSC Enthusiast

  Points: 179

  More actions

  December 7, 2010 at 7:45 am

  #146534

  Afternoon,

  I would like to store a blob of xml in a table & then show the data in a view, I tried a number of routes (mostly found on the forums) but nothing seems to quite fit. I'm guessing I'm just doing it wrong. This is the type of xml which I plan to store

  <skewfactors official="false" user="elyjo" machine="abc123" region="London" createtiontime="2010-12-04 14:12:56">

  <datarow portfolio="CDX series 9" version="V2">

  <tenor name="5y" RefLevel="34">

  <tranche name="0-3">

  <upfBidPrem>0.56</upfBidPrem>

  <upfMidPrem>0.58</upfMidPrem>

  <upfAskPrem>0.60</upfAskPrem>

  </tranche>

  <tranche name="3-5">

  <upfBidPrem>0.70</upfBidPrem>

  <upfMidPrem>0.72</upfMidPrem>

  <upfAskPrem>0.72</upfAskPrem>

  </tranche>

  </tenor>

  <tenor name="7y" RefLevel="43">

  <tranche name="0-3">

  <upfBidPrem>.48</upfBidPrem>

  <upfMidPrem>.50</upfMidPrem>

  <upfAskPrem>.052</upfAskPrem>

  </tranche>

  </tenor>

  </datarow>

  Any idea/pointers would be a great help

• Nicola Jones

  SSC Enthusiast

  Points: 168

  More actions

  December 9, 2010 at 8:03 am

  #1260574

  Is your problem storing it or viewing it?