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



请，请参阅以下查询：

"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?