Archives of the TeradataForum

Message Posted: Mon, 06 Jan 2003 @ 09:05:41 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello all,

The following is the query which gives me the error message in the subject. If I cast anyone of these as dec(15,1) I am losing data accuracy. There are 200 thousand rows in my table.

Can anybody suggest a work around to get the accurate result?

select
        l_abcd,
        l_efgh,
        sum(cast(l_ijkl as decimal(15,2)) * (1 - cast(l_mnop as decimal
(15,2))) * (1 + cast(l_qrst as decimal(15,2)))) as sum_ofcol,
from
        TABLE01
where
        l_uvwx <= date '1996-10-11' - interval '45' day
group by
        l_abcd,
        l_efgh
order by
        l_abcd,
        l_efgh;

Thanks all

Anonymous

	<Prev	Next>		<<First	<Prev	Next>	Last>>