Archives of the TeradataForum

Message Posted: Thu, 26 May 2011 @ 07:54:50 GMT

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

Hi John,

Your assumption is correct (capturing changes in the first three fields and create new rows in the result table with updated start/end dates accordingly. Note that the start/end dates in the first row of the result covers from 01/01/2011 to 10/03/2011.

Alan

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