Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 18 Oct 2007 @ 12:20:19 GMT

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

Subj:   Re: Conditionally Converting a Many to One relationship
From:   Victor Sokovin

  Has anyone coded this kind of thing before? I tried coding this with nested IF and case statements but it doesn't seem to work. The only way I can get it to work is by creating multiple staging tables but I was hoping this could be programmed in a loop of some kind.  

I think you can accomplish this easily if you use such set operators as MINUS or INTERSECT. You can store all your standard sets (and their codes) in one reference table and compare them to the attribute value sets for each item in your main table. If you use MINUS and find that the difference of the sets is NULL for a certain standard set then <Bingo!> you've got the code you were looking for.



  <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