Archives of the TeradataForum
Message Posted: Tue, 29 Mar 2005 @ 18:43:43 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|