Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 07 Mar 2012 @ 21:38:53 GMT


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


Subj:   Re: Insert When
 
From:   Kenneth Hansen

Not that I know but I would UPSERT was the most common method of "Update if record exists else insert if it does not" but if you want two separate tables you could look at insert via a View that joins two tables or simply run two inserts: Insert into t1... from S1.. where ... followed by Insert into t2 ... from S1... where in (sel ... from S1... minus ... t1)


Kenneth Hansen



     
  <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