Archives of the TeradataForum
Message Posted: Fri, 23 Jul 2010 @ 13:53:46 GMT
I think that what you need is recursive sql - I'm assuming that you're on V2R6+. Look in the SQL /DML reference manual for details.
It is still worth limiting the number of iterations (i.e. recursions) but at least the main bit of processing is a single statement.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|