Archives of the TeradataForum

Message Posted: Wed, 09 Dec 2009 @ 17:40:15 GMT

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

Paul,

I'm curious about why & when you're doing an update like this. The Oracle query won't guarantee the same ROWNUM for a given row unless you've specified a unique order by that also won't change if new rows are included, so if you're assigning a surrogate key you have to be careful. What are you trying to achieve with the update? Maybe we can come up with something even more efficient....

Dave C

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