asked on

XML to SQL table

Hi, Have a problem getting the data from the nodes "ItemID"
It looks like this:

<Body>
<Line ID="10">
<ItemID Type="Techdata">2869909</ItemID>
<ItemID Type="Manufacturer">F7N060B2C00</ItemID>
<ItemID Type="EAN">722868996157</ItemID>
<ItemID Type="CommodityCode">4202918090</ItemID>
<CountryOrigin>TW</CountryOrigin>
<ItemText>Cinema Stripe Cover Blacktop iPad Air</ItemText>
<ItemQty Type="delivered">5</ItemQty>
<ItemWeight Type="Net" Unit="kg">1.6</ItemWeight>
<ItemReference>
<CustLine>1</CustLine>
</ItemReference>
</Line>

And I need to extract these data:
<ItemID Type="Techdata">2869909</ItemID>
<ItemID Type="Manufacturer">F7N060B2C00</ItemID>
<ItemID Type="EAN">722868996157</ItemID>
<ItemID Type="CommodityCode">4202918090</ItemID>

How can I get the data in these lines?

Any help is very much appreciated.

Petter.

SOLUTION

ste5an

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Prakash Samariya

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial