Archives of the TeradataForum

Message Posted: Tue, 25 Feb 2014 @ 17:10:52 GMT

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

David,

What do you mean in your original post by the following comment?

"The only other thought was to use a SET Table in order to avoid total duplicates, but this only results in both of the duplicates being discarded."

If you insert 3 duplicates rows into a SET table then the first will be there and the second and third ones will be rejected. What am I not understanding here?

Cheers,

Dave

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

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