On Thu, 28 Sep 2006 20:37:33 GMT, Don wrote:

>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 wrote:

> 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" <unknown@oblivion.com> wrote in message
news:aecTg.65594$5R2.15178@pd7urf3no...
> Sorry, I'm a bit too busy to create more details for this oddity. It's
> part of a larger query, so maybe that was affecting something. When I
> tried doing to two different summations alone, they both returned decimal
> values.
>
> It's not big deal. I was just curious as to why it behaved that way. I
> must've missed something. No worries.
>
> - Don
>