Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 19 Mar 2008 @ 22:09:07 GMT


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


Subj:   Re: Can I avoid a product join?
 
From:   Duell, Bob

Sorry for the late acknowledgement, but I wanted to thank all who responded to my question.

The obvious answer was "no", I cannot avoid a product join. The best suggestion was to create a "product id" and add that to the "Customer" table. That's something I can do (actually by building a separate "helper" table, since I can't change the original).

I was wondering, would something like this be possible/practical with a UDF? It seems like a natural fit for a function (send a code, do a lookup, return a result). I'm just asking. Most of my experience is with SAS and that's how I'd solve the problem.

Anyway, thanks very much for all the advice. As usual, I learned something new.


Bob



     
  <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