Archives of the TeradataForum

Message Posted: Wed, 17 Nov 2004 @ 20:43:52 GMT

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

Thanks Jim! However, its not that I'm having a problem with the optimizer; I just want to know the method since it is supposed to be just one line of query versus thousands of lines if I have to write case statements for each interval 500-100,1001-1500,1501-2000,....upto 1 million.

Thanks!

Lakme

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