Archives of the TeradataForum

Message Posted: Thu, 29 Mar 2012 @ 11:29:58 GMT

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

Please try this.

1. Create a SET table with same structure.

2. Insert records to SET table selecting all records form MULTISET table, it will automatically delete duplicate records.

3. Drop Multiset table.

Thanks,

Sughesh I S

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