Archives of the TeradataForum

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

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

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>>