remove duplicate rows in sql server 2008 using asp.net

Question

1.00/5 (1 vote)

See more:

Hello guys
I have two table
one is main table and
second is DNC.
In main table I have 5 columns...id,name,phone_number,address,city
In DNC table I have only one column that is phone_number.

I have to do.....match two table and remove data from main table which is presented in DNC.....using asp.net
please help me....

Posted 24-Nov-15 23:59pm

Member 11874141

Add a Solution

Comments

CHill60 25-Nov-15 6:08am

What have you tried?
Do you really mean "duplicate rows" - it sounds like you want to remove data from one table if it exists in another table - that is a very different thing to removing duplicates

aarif moh shaikh 25-Nov-15 6:09am

user sub-query for it..

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

PANKAJMAURYA · Answer 1 · 2015-11-25T00:13:00

Try

C#

public static void DeleteDuplicateEntry()
     {        
         using (SqlConnection cn = new SqlConnection("YourConnectionStringName"))
         {
             SqlCommand objComm = new SqlCommand("delete from MainTable where phone_number in (select phone_number from DNC)", cn);
             objComm.CommandType = CommandType.Text;
             cn.Open();
             objComm.ExecuteNonQuery();
         }         
     }

CHill60 · Answer 2 · 2015-11-25T00:18:00

Solution 2

As you have said "remove data" - if you do not want to delete the entire row, but just remove the phone number from the Main table then replace the query in the SqlCommand with

SQL

update Main SET phone_number = '' FROM main INNER JOIN DNC on Main.phone_number = DNC.phone_number

Posted 25-Nov-15 0:18am

CHill60

Comments

Member 11874141 30-Nov-15 1:22am

dear i want delete that row... not a specific column

CHill60 30-Nov-15 4:14am

That's fine - use solution 1 in that case. I only posted this alternative as it wasn't clear from your post exactly what you wanted to do. To me "remove data" means "remove the content".