Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 20 Oct 2005 @ 12:36:41 GMT


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


Subj:   Re: History treatment Using Upsert Logic
 
From:   Mogilevsky, Boris

I have not heard that there is any way to mark a particular record in SQL, you are always working with record set as a whole.

I had to do a similar task, so I do a left outer join of incoming data with the data which is already in the table, for those records which match I bring the value of the field from the target table(it is my right side of the join) to the incoming data (it is left side of my join).


Boris Mogilevsky
Programmer Analyst



     
  <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: 15 Jun 2023