It's not yet all 55 million rows, it occurs near 100 K records.

I want to remove duplicates from this kind of data (100K) out of 55 millions.

Here is the script

--INPUT

CREATE TABLE #TMP (NAME_1 VARCHAR(300))

INSERT INTO #TMP VALUES ('DR AARON SASAKI SASAKI AARON MD')

INSERT INTO #TMP VALUES ('DR ALBERT LUGO ALBERTO LUGO DMD PC')

--OUTPUT

I would like...

Thansk John. It works fine

DECLARE @test-2 TABLE (a int, b int)

insert into @test-2 values (1,2)

insert into @test-2 values (2,1)

insert into @test-2 values (3,1)

insert into @test-2 values (4,1)

insert into @test-2 values (1,4)

This is my table...