Archives of the TeradataForum

Message Posted: Fri, 14 Apr 2006 @ 17:47:32 GMT

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

Just want to throw in an FYI for the row_number()over (order by <columnname>)

Make sure that the columnname (or columnnames) is very unique or you will still see a "hot amping" issue. You just happened to come across this today and found that the columnname needs to be unique in order to prevent spooling issues caused by "hot amping". A suggestion would be to use the UNIQUE PRIMARY INDEX column/s as your order by (provided you a have an UPI)or any combination of columns.

     row_number()over (order by a,b,c)

KRT

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