Archives of the TeradataForum
Message Posted: Thu, 05 Sep 2002 @ 16:48:16 GMT
I tried a similiar query and got the following error:
3627: Distinct Aggregate Expressions have been used in an invalid space
Try replacing 'Else 0' with 'Else Sum(0)'. I think the problem is that you have an aggregate function in the 'Then' logic and no aggregate function in the 'Else' logic.
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|