Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 13 Dec 2013 @ 15:16:23 GMT

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

Subj:   Re: Conditional Update with CASE
From:   Sughesh.Sumansingh


Could you please try to put your source values in temp table (VT or derived table) and do an update main table joining with temp.

If your source have less variation, it may be easy to put different values in different temp table.

If values are widely varies, it may be difficult.

I am not sure, Please try and let me know.



  <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: 24 Jul 2020