Archives of the TeradataForum

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

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

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>>