Big error:
select ac_code,
SUM(case when acd_year < 2006 then acd_amt else 0.0000001 end)
from .....
rounds to INTEGER,
but when
select ac_code,
SUM(acd_amt)
from .....
result is good.
Any help from PROGRESS support Team ??
Adam
>> Stay informed about: PROGRESS is NOT SQL-92 compatible