Archives of the TeradataForum

Message Posted: Sat, 09 Jul 2005 @ 11:57:54 GMT

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

Anomy Anom wrote:

If table1 is a small table try Michael's solution, but if that table is large, it's too slow.

A better way would be using a temp table, insert those values in it and join to it within that macro.

I once posted a way without temp table by splitting the input value into it's parts:

www.teradataforum.com/teradata/20020719_121740.htm

Dieter

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