Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Mar 2007 @ 11:44:32 GMT


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


Subj:   Cursors - passing variables to system test...
 
From:   Watson, Chris

Hi all,

I am looking to pass in variables to some select statements, for example in the following statement I am looking to pass in a number of different values for a, e and g (from a temp table, variable etc).

     SELECT a FROM b WHERE d = e AND f = g

This doesn't seem as straightforward as it would be using cursors in sql server. Any ideas anyone?



     
  <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