Archives of the TeradataForum

Message Posted: Sat, 06 May 2006 @ 19:57:46 GMT

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

The answer depends on the database release.

As of V2R6.0 there is an equivalent construct called WITH RECURSIVE.

Example:

www.teradataforum.com/teradata/20040920_205008.htm .

On earlier releases, there is no ready-to-use equivalent. If you are still using them then you have to write your own code. A stored procedure can be considered for reasonable data volumes.

Regards,

Victor

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