請教numeric類型的添減運算
日期：2014-05-17 浏览次数：20475 次
請教numeric類型的加減運算
numeric類型字段相加減結果為NULL值,
請教如何解決
萬分感謝
SELECT STORE.MB001,STORE.LB003+LA003 AS 'QUANTITY'FROM
(
SELECT C.MB001,A.LB003 ,B.LA003
FROM
--料號
(SELECT MB001 FROM INVMB WHERE MB005='111') C
LEFT JOIN
-- 期初庫存
(select LB001,LB002,LB003
from INVLB a,INVMB c
where not exists (
select 1 from INVLB b
where b.LB001 = a.LB001
and b.LB002 > a.LB002
) AND a.LB001=c.MB001 AND c.MB005='111') A
ON C.MB001=A.LB001
LEFT JOIN
--後發生的交易數量
(
SELECT LA001,SUM(LA005*LA011) AS LA003
FROM INVLA,INVMB
WHERE LEFT(LA004,6)>=(select TOP 1 MAX(LB002) FROM INVLB)
AND INVLA.LA001=INVMB.MB001 AND INVMB.MB005='111'
GROUP BY LA001
) B
ON C.MB001=B.LA001
) STORE
------解决方案--------------------
用 isnull（column，0）
------解决方案--------------------
没问题啊，是不是你的数据问题？
numeric類型字段相加減結果為NULL值,
請教如何解決
萬分感謝
SELECT STORE.MB001,STORE.LB003+LA003 AS 'QUANTITY'FROM
(
SELECT C.MB001,A.LB003 ,B.LA003
FROM
--料號
(SELECT MB001 FROM INVMB WHERE MB005='111') C
LEFT JOIN
-- 期初庫存
(select LB001,LB002,LB003
from INVLB a,INVMB c
where not exists (
select 1 from INVLB b
where b.LB001 = a.LB001
and b.LB002 > a.LB002
) AND a.LB001=c.MB001 AND c.MB005='111') A
ON C.MB001=A.LB001
LEFT JOIN
--後發生的交易數量
(
SELECT LA001,SUM(LA005*LA011) AS LA003
FROM INVLA,INVMB
WHERE LEFT(LA004,6)>=(select TOP 1 MAX(LB002) FROM INVLB)
AND INVLA.LA001=INVMB.MB001 AND INVMB.MB005='111'
GROUP BY LA001
) B
ON C.MB001=B.LA001
) STORE
------解决方案--------------------
用 isnull（column，0）
------解决方案--------------------
没问题啊，是不是你的数据问题？
DECLARE @a NUMERIC
SET @a=123
DECLARE @b NUMERIC
SET @b=234
SELECT SUM(a)
FROM (
SELECT @a A
UNION
SELECT @b A)a
/*
---------------------------------------
357
*/
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
