currency value is out of range
toolsprdpropor*(tv_query_2.latest_cost)*(tv_query_3.latest_cost*tv_query_3.actualcapacity) as toolsprdpropor
做乘法没问题
下面做除法就有问题了
toolsprdpropor*(tv_query_2.latest_cost)/(tv_query_3.latest_cost*tv_query_3.actualcapacity) as toolsprdpropor
tv_query_2与tv_query_3都是零时表
latest_cost在SQL里面是money类型,toolsprdpropor是decimal类型,actualcapacity是int类型
所以我就不太明白怎么弄了