Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 01 Dec 2003 @ 12:45:13 GMT


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


Subj:   Re: Inconsistent behaviour of 'Coalesce' function in VB application
 
From:   Jim Downey

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

select Case
When ColumnName Is Not NULL then ColumnName
Else 0
End
from SomeTable
;



     
  <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