Archives of the TeradataForum

Message Posted: Thu, 29 Mar 2012 @ 11:02:31 GMT

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

I hope this works

Create a temporary table Temp1 which would be a exact replica of your MULTISET table(Temp).

1. CT Temp1 as Temp with no data;

2. INSERT INTO Temp1 SELECT DISTINCT * from Temp

3. Delete FROM Temp ALL;

4. INSERT INTO Temp SELECT * FROM Temp1;

5 Drop table Temp1;

Regards,

Amogh Badnikar
IDW Technical Consultant

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