|
|
Posted by Don on 10/12/06 17:16
I discovered what I had missed. The "scale" property for some of the
decimal fields was set to 0. This caused the COALESCE() function to
truncate the fractions.
- Don
"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
>
Navigation:
[Reply to this message]
|