Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 01 Dec 2003 @ 14:36:17 GMT

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

Subj:   Re: Inconsistent behaviour of 'Coalesce' function in VB application
From:   Victor Sokovin


On Mon, 1 Dec 2003 07:45:13 -0500, Jim Downey wrote:

  Why would you do the union all. Wouldn't the following work? The advantage would be one pass of the table.  

The originator of this thread had tried the 'case' construction and reported that it did not work. This seems to be 'consistent' as 'coalesce' is only a shortcut for the 'case'. 'Union' seems to be the only alternative left, alas.



  <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: 23 Jun 2019