InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:08:23 GMT20http://www.teradata.com/teradataforum/Topic11946-9-1.aspxIt's done by using AND clause with multiple WHEN(condition) in same CASE statement instead of cascade.Wed, 25 Jun 2008 00:30:16 GMTsakthiganeshthttp://www.teradata.com/teradataforum/Topic11946-9-1.aspxDoes teradata allow to use cascading case statements.Likesum(case when exp1 then Case when exp2 then EndElse EndIf yes will there be a performance issue? Each cascade condition actually has a join on a different table (ie records qualifying in exp1 of case1 from table1 will be checked in exp2 of case2 which will again join with table2) .say exp1 would be a.col1=b.col1 when this satisfied exp2 would be b.col2=c.col1If there would be a performance issue with this approach let me know if there is a better way to get this done.Mon, 23 Jun 2008 03:49:05 GMTsakthiganesht