tttttttt

Anonymous User 7/14/2005 4:02:48 AM

you could get all distinct records to a temporary table, delete everything in the main table, then copy the distinct records back:

CREATE TABLE Dups (FirstName varchar(10), LastName varchar(10))
GO

INSERT INTO Dups VALUES ( 'Robert', 'Aide')
INSERT INTO Dups VALUES ( 'David', 'Koidl')
INSERT INTO Dups VALUES ( 'Hongbo', 'Li')
INSERT INTO Dups VALUES ( 'Robert', 'Aide')
INSERT INTO Dups VALUES ( 'David', 'Koidl')
INSERT INTO Dups VALUES ( 'Hongbo', 'Li')
INSERT INTO Dups VALUES ( 'Robert', 'Aide')
INSERT INTO Dups VALUES ('David', 'Koidl')
INSERT INTO Dups VALUES ('Hongbo', 'Li')
INSERT INTO Dups VALUES ('Robert', 'Aide')
INSERT INTO Dups VALUES ('David', 'Koidl')
INSERT INTO Dups VALUES ('Hongbo', 'Li')
GO

--CREATE A TEMPORARY TABLE THAT HAS THE SAME SCHEMA AS MAIN TABLE
create table #dupstemp (FirstName varchar(10), LastName varchar(10))
--NOW GET DISTINCT VALUE FROM MAIN TABLE
INSERT INTO #dupstemp select distinct * from dups
--DELETE EVERYTHING FROM MAIN TABLE
DELETE FROM dups
WHERE
EXISTS
(
SELECT
*
FROM
dups DupsInner
WHERE
DupsInner.FirstName = Dups.FirstName
AND DupsInner.LastName = Dups.LastName
)
GO

--NOW COPY DISTINCT VALUES BACK IN
INSERT INTO dups select * from #dupstemp

--VOILA
select * from dups

Anonymous User 4/19/2005 7:16:20 PM

What would be the best if you do not have a field with a unique number like the ID field.

Anonymous User 3/30/2005 2:46:35 AM

good

Anonymous User 12/14/2004 4:52:51 PM

good

Anonymous User 11/7/2004 9:59:43 PM

Your Comments (required):i receive duplicate mails in my outlook when i access my mailbox other locations of company.all locations are connected by leased line.i am not getting where the problem is ..??? fonly few of my users face this problem..where could be the problem? server or outlook

sopan6/28/2004 3:24:08 AM

This query is the best way in terms of performance for a large database query over internet?

Fernando5/19/2004 10:20:56 AM