Archives of the TeradataForum

Message Posted: Tue, 02 May 2006 @ 09:44:01 GMT

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

there is nothing like system generated sequence in TD , it is only unique number generation which may be in sequence or out of sequence as you have indicated. Ideal way is to make use of either CSUM or row_count().

HTH

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