除以零错误 [英] Divide by zero error

问题描述

我得到零除错误。



请帮助我。

Hi, I am getting a divide by zero error.

Please help me in this.

CASE U.BasePool 
 WHEN 0 THEN 'N/A'
 WHEN -1 THEN 'N/A'
ELSE CASE 
 WHEN SUM(SUM(B.TransactionCount)) 
        OVER (Partition by U.ContractID) > U.BasePool 
      THEN 'IN-OVERAGE'

--WHEN SUM(SUM(B.TransactionCount)) OVER (Partition by U.ContractID) + (SUM(SUM(B.TransactionCount))  OVER (Partition by U.ContractID)/MonthNum) > U.BasePool THEN DATEADD(MM, 1, GETDATE())

ELSE CONVERT(VARCHAR(20),DATEADD(MM,CAST(ROUND((U.BasePool - SUM(SUM(B.TransactionCount))  
  OVER (Partition by U.ContractID))/(SUM(SUM(B.TransactionCount))
  OVER (Partition by U.ContractID)/MonthNum),0) as INT), GETDATE()),101)
								
--(basepool - sumcontract) / (sumcontract/monthNum ) is the expected months to reach overage	END 

 END AS  ExpectedDate

如何处理除以零的错误？

How to handle the divide by zero error?

推荐答案

我得到零除错误 - 根本没有提供信息。



请，请参阅以下查询：

"I am getting a divide by zero error" - is not informative at all.

Please, see below query:

DECLARE @tmp TABLE (ID INT IDENTITY(1,1), Code INT, myVal INT)

INSERT INTO @tmp (Code, myVal)
VALUES(1,1)
INSERT INTO @tmp (Code, myVal)
VALUES(1,2)
INSERT INTO @tmp (Code, myVal)
VALUES(1,3)
INSERT INTO @tmp (Code, myVal)
VALUES(1,8)
INSERT INTO @tmp (Code, myVal)
VALUES(2,0)
INSERT INTO @tmp (Code, myVal)
VALUES(2,0)
INSERT INTO @tmp (Code, myVal)
VALUES(2,0)
INSERT INTO @tmp (Code, myVal)
VALUES(3,12)
INSERT INTO @tmp (Code, myVal)
VALUES(3,9)
INSERT INTO @tmp (Code, myVal)
VALUES(3,8)

SELECT Code, CONVERT(INT, 100/SumOfMyVal) AS Dev
FROM (
	SELECT Code, SUM(myVal) AS SumOfMyVal
	FROM @tmp
	GROUP BY Code
) AS T
WHERE T.SumOfMyVal>0

你看到我用过什么样的技巧？

Do you see what kind of trick i have used?

这篇关于除以零错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！