clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1716874 fiddles created (23891 in the last week).

create table t(data xml); insert into t values ( '<ROOT> <CATEGORY name="A"> <PRODUCT NetAmount="10.50"/> <PRODUCT NetAmount="20.50"/> </CATEGORY> <CATEGORY name="B"> <PRODUCT NetAmount="30.50"/> <PRODUCT NetAmount="40.50"/> <PRODUCT NetAmount="75.50"/> </CATEGORY> </ROOT>' );
1 rows affected
 hidden batch(es)


select d.lin.value('./@NetAmount', 'decimal(10,2)') as Amount from t cross apply data.nodes('ROOT/CATEGORY/PRODUCT') as d(lin);
Amount
10.50
20.50
30.50
40.50
75.50
 hidden batch(es)