By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

Arithmetic overflow or other arithmetic exception occurred

P: 1
Hi there,

I got the above error trying to execute the following:
SELECT ...
.
.
CASE WHEN x = 100
THEN 0
ELSE CAST(y * x AS BIGINT)
END AS new_x
.
.
.
x is INT, so I have chosen the BIGINT for y*x, but still got the same error.

Thanks in advance,
So
Sep 11 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.