Archives of the TeradataForum

Message Posted: Thu, 17 Jan 2008 @ 11:21:15 GMT

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

Have you considered using OLAP functions ?

You should be able to use ROW_NUMBER() in your SQL to generate unique contiguous values in the resultset.

rgds

Joseph D'silva

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