Archives of the TeradataForum
Message Posted: Wed, 21 Dec 2005 @ 14:47:51 GMT
| Subj: | | Re: Passing the value for an IN clause to a stored |
| |
| From: | | David Clough |
What I'd do in this situation Matt, is to string the inputs together into a locally declared variable and then execute dynamic sql, rather than
the static sql as it currently is.
That dynamic sql would write the values into a Global Temporary table, from which you can then easily retrieve the values.
Just a thought.
If it works Matt then you owe me a beer!
_______________________
Dave Clough
Database Designer
Express ICS
www.tnt.com
| 
