Sum 函数的执行出错，提示“Arithmetic overflow error converting expression to data type int.”，怎么解决？

[Linda_xu]

一个SQL语句：
SELECT sum(isnull(Qty,0)) FROM Trans GROUP BY Customer
执行完毕后提示出错。
“Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.”

要怎么解决这个问题呢？

[WangZWang]

SELECT sum(cast(isnull(Qty as float,0)))
FROM Trans GROUP BY Customer

[WangZWang]

SELECT sum(cast(isnull(Qty,0) as float))
FROM Trans GROUP BY Customer

[Linda_xu]

对了，谢谢