Archives of the TeradataForum

Message Posted: Thu, 05 Sep 2002 @ 21:58:39 GMT

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

use a "derived table' to select the existing table columns and the incrementing_number can be some arithmetic function (OLAP function like CSUM, or RANK) on the PK column(s); or some other table info that you could join to, etc.

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