Archives of the TeradataForum

Message Posted: Thu, 20 May 2004 @ 15:50:50 GMT

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

The only point I'd add to those already mentioned is that it's easier to return multi-row answer sets in a macro, such as you might do if you have several rows with the same NUPI value that qualify from PI access. With a stored procedure you might have to insert each NUPI row into a temp table, then access that temp table after the SP completes...or you could use IF THEN...ELSE and cursor logic in the SP to loop through the NUPI rows.

For simple stuff and multi-row answer sets, macros offer an advantage both in performance and ease of use.

Thanks, --Carrie

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