Archives of the TeradataForum
Message Posted: Thu, 20 May 2004 @ 15:50:50 GMT
| Subj: || || Re: Stored Procedure vs. Macro |
| From: || || Ballinger, Carrie |
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
For simple stuff and multi-row answer sets, macros offer an advantage both in performance and ease of use.