Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Handling common SQL blocks in a Stored Proc
 
From:   Gregg, Bill

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016