Archives of the TeradataForum

Message Posted: Thu, 15 Jun 2006 @ 09:48:52 GMT

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

My suggestion is to investigate how the table is populated and try to "implant" a parallel process which would calculate the results you require.

What you see in the table is called "sparse rank". What you want to calculate is called "row number". Please refer to the following thread to get more information on different forms of ranking for ordered data sets:

www.teradataforum.com/teradata/20050724_152509.htm .

Regards,

Victor

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