Archives of the TeradataForum

Message Posted: Tue, 13 Nov 2001 @ 18:00:29 GMT

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

Tom,

With an Insert/Select statement, Teradata will silently discrd any duplicate rows. In your case, every row is a duplicate, hence every row gets discarded (zero rows inserted) and so there are no duplicate PI values encountered.

Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

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