Hi,
I have xml like below.
<Activity>
<ID>2000790721500-85</ID>
<Net>6.00000000000001E-02</Net>
</Activity>
i try to read xml into table like below
SELECT
ID = CL.Activity.value('(ID)[1]', 'varchar(50)'),
Net = CL.Activity.value('(Net)[1]', 'decimal(18,3)')
FROM
@XML.nodes('/Advice/Activity') CL(Activity);
in that xml the 'Net' value is some thing different(6.00000000000001E-02) which am receiving. while i read that value i face the below exception.
Error converting data type nvarchar to numeric.
how to fix that problem
Thanks
Kasim