Posted by Don on 11/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

[Back to original message]