Arithmetic overflow error converting expression to data type int

Question

Post reply

Arithmetic overflow error converting expression to data type int

davidl 27298

SSC Enthusiast

Points: 193
More actions
March 25, 2015 at 1:07 pm

#302518

Help
in my sql statement, I don't have any datatype as INT, when I run it, give me error as 'Arithmetic overflow error converting expression to data type int'.
example :
select column1, 2, 3 .....
from (select sum(float) as column1 , ....)
when I hop my curser on top of column1, it shows (int,null)
any idea?
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47068 More actions · Answer 1

and when you hover your cursor over the "float" column, does it say float?

I'm wondering if you have a case of mistaken identity - are you using two part naming on all your columns to ensure you are referencing the right column from the right table?

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

davidl 27298 SSC Enthusiast Points: 193 More actions · Answer 2

and when you hover your cursor over the "float" column, does it say float?

Yes, it says float

I'm wondering if you have a case of mistaken identity - are you using two part naming on all your columns to ensure you are referencing the right column from the right table?

Double make sure, that I referenced the right column from right table(temp table created on the runtime)

DouglasH SSCommitted Points: 1669 More actions · Answer 3

The tooltip showing the datatype is a quirky feature that sometimes returns the wrong information. The reason it is showing INT is because it thinks SUM returns an INT. It's an intellisense/tooltip issue only, if the query is correctly written, it doesn't matter what the tooltip says.

I don't think that's the cause of your 'arithmetic overflow' error, you'll have to show the full query and table creation sql and I'm sure someone will help.

davidl 27298 SSC Enthusiast Points: 193 More actions · Answer 4

thanks, found the problem. actually it is not in this segment of T-code, it is in the next segment.

I have a sum (int) it is overflowed to the size. thanks for the help