Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023