Hi all,

Im having two tables with 1 crores of record each. I want to avoid its duplication.But when im giving the query in query analyser for that.Its giving an error that,connection broken.Or sometimes in main window its giving time expired. What shoul i do for this. Kindly help me.

Thank You.

Jeen

When you say duplicate, is it just for one column or multiple columns?

We need to see the query, and then the indexes on the table.

Hi,

Actually my table deals with mobileno: and the detail such as message,language,place,category.

This records are used for sms purpose. So i need the distinct values of that tables.

Eg: select distinct * into tablename from tablename

But in this case i wil get mobileno duplication.ie,one person can send different mess.So it wil display

mobileno   mess    lang   category

12345        hai         eng     text

12345        hi            eng      text

My main problem is that its giving error connection broken,time expired etc.

Wat is the solution for this?

Help pls.

Thank You

Jeen

Do it in batches ... 

SET ROWCOUNT 1000

INSERT INTO target (column_list)
SELECT DISTINCT .........
FROM ........

WHILE @@ROWCOUNT > 1
BEGIN
   INSERT INTO target (column_list)
   SELECT DISTINCT .........
   FROM source
   WHERE NOT EXISTS (SELECT * FROM target WHERE target.key = source.key)
END

SET ROWCOUNT 0