Hi

I am worling on sql server 2000.
I have 2 ques
1. I want to delete the duplicate rows from my table
key is suppid and empid means want to delete duplicate records of same suppid and empid.

2.I have one table with 10 fields.I dont have any primary key in this table.when i perform the delete operation (just delete from table no more where conditions) its taking long time to delete.
is there any way to speed up it can i create index on this table if can to which field i have to create because i dont have any where condition in my sql query.

Pl help me thanks

Dear it will be good for you if you post this topic in the data base forum and as far as my knowledge is concern for 1st problem
You may create a new table and all the records from old table to new table using

distinct function of SQL


(*_*)

Numan
--------------------------------------------------
Love is the most precious thing of this world. So find and grab it!