Archives of the TeradataForum

Message Posted: Fri, 23 Jul 2010 @ 13:53:46 GMT

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

Hi Chris,

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.

Regards,

Dave

Ward Analytics Ltd - Information in motion ( www.ward-analytics.com )

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