Archives of the TeradataForum

Message Posted: Tue, 29 Mar 2005 @ 18:43:43 GMT

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

The programming staff has implemented some (extremely long) stored procedures that have common chunks of SQL code. (In each case, the stored proc is one SQL call that uses derived tables at several spots.)

We would like to simplify the maintenance and add some structure to the SQL. One suggestion is to capture the calls against the derived tables in views which would then be invoked by the stored proc.

Has anyone encountered a similar situation? If so, what were the solutions? Your ideas are welcome!

Thanks,

Bill Gregg

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