Posted by Hugo Kornelis on 09/25/08 11:59

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?

Hi Don,

Can you please post a full repro script? (That is, post CREATE TABLE
statements, INSERT statements and SELECT statements to reproduce this
behaviour in an empty database).

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: Subquery doesnt work!!!!!!!!!!!
• Prev in forum: Re: get todays date and a certain time
• Thread view: Re: Unexpected Casting With Sum & Coalesce

[Reply to this message]