物料收发明细表查询时报错
金蝶云社区-LeoX
LeoX
1人赞赏了该文章 667次浏览 未经作者许可,禁止转载编辑于2018年02月07日 11:12:10


把这段SQL拿到数据库运行,发现是红色部分计算算术溢出,怎么处理?这个是系统错误啊

SERT INTO TMPF61772320BB311E8940A90E2BA1 (FGUID, FIOPRICE, FQCAMOUNT, FMATERIALID) SELECT LOWER(NEWID()) fguid, CASE WHEN SUM(ISNULL(THIB.FQTY, 0)) = 0 THEN 0 ELSE CAST((CAST(SUM(THIB.FAMOUNT) AS NUMERIC(23, 10)) / SUM(THIB.FQTY)) AS NUMERIC(23, 10)) END fioprice, SUM(THIB.FAMOUNT) fqcamount, THS.FMATERIALID FROM T_HS_INIVSTOCKDIMENSION THS INNER JOIN T_HS_INIVBALANCE THIB ON (THS.FENTRYID = THIB.FDIMEENTRYID AND THIB.FENDINITKEY = '0') INNER JOIN T_HS_OUTACCTG THO ON THIB.FID = THO.FID INNER JOIN T_HS_CALDIMENSIONS TCH ON TCH.FDIMENSIONID = THO.FDIMENSIONID LEFT OUTER JOIN T_BD_LOTMASTER TBLM ON ISNULL(THS.FLOT, 0) = TBLM.FLOTID WHERE (((((TCH.FACCTSYSTEMID = 1 AND TCH.FFINORGID = 1) AND TCH.FACCTPOLICYID = 1) AND THO.FYEAR = 2018) AND THO.FPERIOD = 1) AND THS.FSTOCKORGID = 1) GROUP BY THS.FMATERIALID