Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Feb 2015 @ 14:40:40 GMT


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


Subj:   Re: SELECT in SQL Scalar Functions
 
From:   Roth, David W

UDFs are meant to be used inline to act upon result set data row by row by passing in parameters and receiving a calculated result.

Either a macro or stored procedure would run the SQL you have shown, so I am going to assume that the problem you want to solve is multiple invocation of the SQL and use of the result in a where clause or case statement.

If this is the case, why can you not use a table to run once, store and use?

We can help more if we know what the problem is


Dave



     
  <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: 27 Dec 2016