To be more specific, the records with the same email, since the whole record is not an exact duplicate. Each record key is still unique.

I am trying to generate some...

Delete original records from a SQL Server database.

Thanks

with Dups as

( SELECT *,row_number()

OVER

(partition by email1 order by email1, id3 desc) as RowNum

FROM outputresume3)

Delete from Dups where rownum > 1;

I ran the above code and am...

Many Thanks !

DECLARE @Table TABLE (id3 int, resume varchar(256), email1 varchar(256))

INSERT INTO @Table

SELECT 454382, 'testresume1', 'abc@hotmail.com' UNION ALL

SELECT 612832, 'testresume2', 'john@global.net' UNION ALL

SELECT 612833, 'testresume2', 'john@global.net' UNION ALL

SELECT 612834, 'testresume2', 'john@global.net'

SELECT...

Many Thanks !

Sample data:

col(id3) col(email1)

454382abc@hotmail.com

612832john@global.net

612833john@global.net

612834john@global.net

I would like the results to be:

454382abc@hotmail.com

612834john@global.net

Since the 454382 record is unique and the 612834 record is the highest id3 (most recent).

Thanks

I am still trying to figure out the best solution !

It is a work in progress 🙂

The only reason i did not use a temp table is that i...

No, i have :

SQL Server program files on - C drive

.ldf on an array on E drive

.mdf on an array on F drive

tempdb on an array on...

Jeffrey Williams (7/2/2009)

---

ifila (7/2/2009)

---

I do have a couple of questions. While testing Jeffrey's solution, is there any way to make it run quicker ?

It took 35 minutes to process 600...

I do have a couple of questions. While testing Jeffrey's solution, is there any way to make it run quicker ?

It took 35 minutes to process 600 000 records !

How...

I just tested Jeffrey's solution and it works ! 🙂

Many Thanks to both of you, for your assistance !

I added a screen shot of my SQL DB.

All resumes are initially imported into dbo.emailaddress which has one big field 'emailaddresstxt'.

READ desktop text folder - WRITE to dbo.emailaddress

At this point...

yes

GilaMonster (7/2/2009)

---

Your sample data doesn't fit in the table specified. Do you mean this as sample data, or should the table have more columns?

Insert into resumein (OriginalResume, OriginalEmail)

Values ('java','...