removing duplicates rows from a parent table.

Question

removing duplicates rows from a parent table.

gopikishan.maheshwarlal

Newbie

Points: 9
More actions
February 15, 2013 at 6:15 am

#289467

Hi all,
i need help in deleting duplicate records from a table a. but the table which i'm going to delete has 2 child tables, table b and table c. Please help me or suggest me how to do that. thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

To help those who want to, and can help you please define the tables, and provide some sample data.

To do this please click on the first link in my signature block and read the article. The article contains the T-SQL statements to perform the above task(s) quickly and easily.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

gopikishan.maheshwarlal (2/15/2013)
Hi all,
i need help in deleting duplicate records from a table a. but the table which i'm going to delete has 2 child tables, table b and table c. Please help me or suggest me how to do that. thanks

Either setup cascading delete foreign keys or delete the children prior to deleting the parent.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 3

Sean Lange (2/15/2013)
gopikishan.maheshwarlal (2/15/2013)
Hi all,
i need help in deleting duplicate records from a table a. but the table which i'm going to delete has 2 child tables, table b and table c. Please help me or suggest me how to do that. thanks
Either setup cascading delete foreign keys or delete the children prior to deleting the parent.

+1

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)