Advertisement

07.06.2008 at 04:29AM PDT, ID: 23541512
[x]
Attachment Details

How to remove duplicate records in SQL table ?

Asked by Gary2Seven in Programming for ASP.NET, Programming Languages, .NET

Tags: asp.net vb.net

Hi Experts,

My question to you is I have a table called tblUser with fields (Id, Email, Name) with duplicates in the table on the email field. What is the best query to use to find out the dupicates in vb.net/asp.net code behind? also then remove the duplicates so i only have one record per email address left.

Thanks for the help. :o)
Start Free Trial
 
Keywords: How to remove duplicate records in S…
Title
1 Duplicate Records
2 Delete Duplicates
3 Duplicate indexes - are they a proble…
4 getting error when adding items to coll…
5 Avoid Duplicate Records?
6 Delete Duplicates
 
Loading Advertisement...
 
[+][-]07.06.2008 at 04:51AM PDT, ID: 21939959

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 04:55AM PDT, ID: 21939967

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 04:57AM PDT, ID: 21939971

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 05:00AM PDT, ID: 21939978

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 05:18AM PDT, ID: 21940020

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Programming for ASP.NET, Programming Languages, .NET
Tags: asp.net vb.net
Sign Up Now!
Solution Provided By: naspinski
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.06.2008 at 05:20AM PDT, ID: 21940026

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 05:30AM PDT, ID: 21940048

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 05:34AM PDT, ID: 21940057

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 05:48AM PDT, ID: 21940083

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 05:52AM PDT, ID: 21940093

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 06:10AM PDT, ID: 21940145

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 06:18AM PDT, ID: 21940174

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 06:22AM PDT, ID: 21940195

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.06.2008 at 07:36AM PDT, ID: 21940466

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628