Duplicate Entries

[just1coder@yahoo.ca]

Does anyone have any examples on how to remove dupliate entries from a
table?

I have 1 temp table that holds about 300,000 records - about 110,000 of
those are [at minimum] duplicates.

The table layout is somethign like:

pk email id
1 [email]me@here.net[/email] 0001
2 [email]you@there.com[/email] 0002
3 [email]me@here.net[/email] 0003
3 [email]me@here.net[/email] 0004
3 [email]me_1@here.ca[/email] 0005

[Aaron [SQL Server MVP]]

Doesn't look like your primary key column (with a terrible name, pk) is not
really a primary key after all.

[url]http://www.aspfaq.com/2431[/url]
[url]http://www.aspfaq.com/2509[/url]
[url]http://www.aspfaq.com/2504[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




<just1coder@yahoo.ca> wrote in message
news:u7H4oWKdEHA.1604@TK2MSFTNGP11.phx.gbl...

> Does anyone have any examples on how to remove dupliate entries from a
> table?
>
> I have 1 temp table that holds about 300,000 records - about 110,000 of
> those are [at minimum] duplicates.
>
> The table layout is somethign like:
>
> pk email id
> 1 [email]me@here.net[/email] 0001
> 2 [email]you@there.com[/email] 0002
> 3 [email]me@here.net[/email] 0003
> 3 [email]me@here.net[/email] 0004
> 3 [email]me_1@here.ca[/email] 0005

[Jeff Cochran]

On Wed, 28 Jul 2004 09:21:35 -0400, [email]just1coder@yahoo.ca[/email] wrote:

>Does anyone have any examples on how to remove dupliate entries from a
>table?
>
>I have 1 temp table that holds about 300,000 records - about 110,000 of
>those are [at minimum] duplicates.
>
>The table layout is somethign like:
>
>pk email id
>1 [email]me@here.net[/email] 0001
>2 [email]you@there.com[/email] 0002
>3 [email]me@here.net[/email] 0003
>3 [email]me@here.net[/email] 0004
>3 [email]me_1@here.ca[/email] 0005

Is PK supposed to be a primary key? Okay, obviously not since it has
duplicates, is ID your primary key? What database, and do you need
this from ASP or just a query? Might look at:

How do I remove duplicates from a table?
[url]http://www.aspfaq.com/show.asp?id=2431[/url]

Jeff

[just1coder@yahoo.ca]

Aaron [SQL Server MVP] wrote:

> Doesn't look like your primary key column (with a terrible name, pk) is not
> really a primary key after all.
>
> [url]http://www.aspfaq.com/2431[/url]
> [url]http://www.aspfaq.com/2509[/url]
> [url]http://www.aspfaq.com/2504[/url]
>

Sorry, in my haste, I forgot to update the PK records. PK is not the
name of the colomn.

Thanks for the links.

[just1coder@yahoo.ca]

Aaron [SQL Server MVP] wrote:

> Doesn't look like your primary key column (with a terrible name, pk) is not
> really a primary key after all.
>
> [url]http://www.aspfaq.com/2431[/url]
> [url]http://www.aspfaq.com/2509[/url]
> [url]http://www.aspfaq.com/2504[/url]
>

Sorry, in my haste, I forgot to update the PK records. PK is not the
name of the colomn.

Thanks for the links.