Hi,
how to read xml data with this format ?
<ram:BilledQuantity unitCode="C62">1.0000</ram:BilledQuantity>
Want to have the value for unitCode and the quantaty of 1.000 !
Or this !
<ram:ChargeAmount currencyID="EUR">14.9500</ram:ChargeAmount>
Want to have “EUR” and amount of 14.9500 !
How to get this in a select statement ?
Thanks for help.