Archives of the TeradataForum

Message Posted: Tue, 30 Jul 2002 @ 14:48:02 GMT

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

I just wanted to follow up with all that this dynamic sql in a stored procedure suggestion worked wonderfully.

The actual Insert\Select statement I have is a very large, complex beast and maintaining multiple versions of it would have been a nightmare. The ideal solution would require only one instance of the code, so even multiple versions in a single macro would have been unpleasant. Thus when the stored procedure worked the ideal solution was found. The only catch was that the procedure had to be created under a User database (the creator and immediate owner had to be the same) and this user db had to have some perm space. That is not quite how our environment was designed but the trade-off is acceptable.

Thanks to everyone for their suggestions and advice. I am definitely off to a great day now.

--Jason

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