Archives of the TeradataForum

Message Posted: Wed, 06 Dec 2006 @ 18:32:10 GMT

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

You have to enclose each COALESCE between (). Something like this:

     SELECT
        ((coalesce(cnt_2_9, 0)) + (coalesce(cnt_30_59, 0)) +
     (coalesce(cnt_60_210, 0))) AS TOTAL,
        CURRENT_TIMESTAMP
     FROM table_a;

Bye,

Castelli, Emanuel Alejandro
Desarrollo DataWarehouse - IBM Argentina

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