Archives of the TeradataForum
Message Posted: Wed, 17 Mar 2004 @ 11:15:09 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|