how to convert xml input to a table in sp

• ASFSDJG

  Mr or Mrs. 500

  Points: 500

  More actions

  April 8, 2011 at 11:53 pm

  #236489

  <root>

  <product>

  <product_id ID = "1"/>

  <product_id ID = "2"/>

  <product_id ID = "3"/>

  </product>

  <discount>

  <discount_id ID ="9"/>

  <discount_id ID ="10"/>

  </discount>

  <tax>

  <tax_id ID = "0"/>

  </tax>

  </root>

  this is my xml input to a stored procedure.

  is it possible to convert this xml to a single table like this

  Product_ID Discount_ID Tax_ID

  1 9 0

  1 10 0

  2 9 0

  2 10 0

  3 9 0

  3 10 0

  and if possible can you please give me the solution

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  April 9, 2011 at 2:46 pm

  #1309572

  Duplicate post, direct comments here: http://www.sqlservercentral.com/Forums/Topic1091056-391-1.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato