Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 05 May 2008 @ 10:57:15 GMT

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

Subj:   Re: Not able to run query on teradata
From:   Narendra Bhatkande

Hi Christian,

Good morning,

Still not able to run this query...

Can't I use the select statement in the 'In' which is in 'when' of 'case' ? like this. --> case when something in select something from some_table) then stmt else stmt end

If I use hardcode values in the place of select statement then it is working but I don't know why It is not working like this..-->case when something in(1000,2000,3000) then stmt else stmt end

Please give me reason why it is so, Or tell me if there is any alternative way to do this.....



Narendra Bhatkande

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020