Archives of the TeradataForum

Message Posted: Wed, 17 Mar 2004 @ 11:15:09 GMT

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

This will give a product of 0 when there are an even number of -ve numbers in the column. So another case is needed to fix this...

case when (n_neg mod 2) = 0 then signum
     else -signum
end

Thanks,

Sanjaya

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