Archives of the TeradataForum
Message Posted: Wed, 20 Feb 2008 @ 09:35:30 GMT
> 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|