Posted by Don on 09/28/53 11:59

If I have an SQL query which returns an aggregate of several decimal fields
like so:

(sum(COALESCE(myDecimal1, 0)+
sum(COALESCE(myDecimal2, 0)+
sum(COALESCE(myDecimal3, 0)) as MyTotal

I get an rounded integer in MyTotal.

However, if I do the following:

sum(COALESCE(myDecimal1, 0)+
COALESCE(myDecimal1, 0)+
COALESCE(myDecimal1, 0)) as MyTotal

I get a (proper) decimal value.


Does anyone know why the first case returns an Integer?

- Don

• Next in forum: Re: this is very, very, very frustrating!!!!!!
• Prev in forum: Re: this is very, very, very frustrating!!!!!!
• Thread view: Unexpected Casting With Sum & Coalesce

[Reply to this message]