34,590
社区成员
发帖
与我相关
我的任务
分享
CASE WHEN A IS NULL OR A=0 THEN 0 ELSE A END
select A.pro_id,
sum(B.pro_amount * B.pro_price)/(case when isnull(sum(B.pro_amount+d.pro_stoamount),0)=0 then 0.0000001 else sum(B.pro_amount+d.pro_stoamount) end) as sums
from ......
DECLARE @I INT
SELECT @I=0
SELECT CASE WHEN @I=0 THEN 你要的结果 ELSE 2/@I END
select A.pro_id,
sum(B.pro_amount * B.pro_price)/(case when sum(B.pro_amount+d.pro_stoamount)=0 then 0.0000001 else sum(B.pro_amount+d.pro_stoamount) end) as sums
from ......