SQL Server : Arithmetic overflow error converting expression to data type int

sql sql-server tsql

Is the problem with SUM(billableDuration)? To find out, try commenting out that line and see if it works.

It could be that the sum is exceeding the maximum int. If so, try replacing it with SUM(CAST(billableDuration AS BIGINT)).


Change SUM(billableDuration) AS NumSecondsDelivered to

sum(cast(billableDuration as bigint)) or

sum(cast(billableDuration as numeric(12, 0))) according to your need.

The resultant type of of Sum expression is the same as the data type used. It throws error at time of overflow. So casting the column to larger capacity data type and then using Sum operation works fine.

Related

Ruby equivalent for Python's "try"?
Center two fonts with different different sizes vertically in an NSAttributedString
Why are unsigned integers error prone?
Determine $\lim\limits_{n \to \infty}{{n} \choose {\frac{n}{2}}}\frac{1}{2^n}$, where each $n$ is even
A Math Olympiad question regarding Geometry
Proof that the sum of the cubes of any three consecutive positive integers is divisible by three.
100-sided die probability
How to show these two definitions of the Riemann integral are equivalent?
Is there always a prime number between $p_n^2$ and $p_{n+1}^2$?
What are the eigenvalues of $\operatorname{ad}x$?
Is the Cantor set a subset of rational numbers, and is it countable or uncountable?
Do the non-units in a commutative ring form an ideal?