Archives of the TeradataForum

Message Posted: Wed, 20 Feb 2008 @ 09:35:30 GMT

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

Hi Howard:

          > Insert into mytable
          > with recursive temp (a2, b2,lvl) as

That is an approach that I had not yet gotten around to trying but it makes absolute sense because the WITH is still before and part of the SELECT.

Thanks so much for sharing because I love learning new things.

Best regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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