How can we delete duplicate records... conditions apply.
-
Due to the fact that having duplicate records within a relational database means somebody somewhere had a stupid attack and created a system without checks and constraints to prevent it from happening.
These people need educating (in a harsh way and should suffer the pain of deleting the data and reinputing it again without duplicates).
Should we be doing the student's homework for them is the other question?
What a ridiculous set of restrictions, it is obviously a homework question.
Notice the origional poster has not even had the good grace to thank you guys, for your brilliant solutions.
--Shaun McGuile
Fix the problem, not the blame!
Hiding under a desk from SSIS Implemenation Work :crazy:
-
Maybe he has already forgotten about this posting due to some other urgent projects or he already resolved this, but we keep wrangling...
-
That should be "DELETED" from the forums
* Noel -
Duplicate records DO happen on staging tables used for preprocessing rows from third parties, especially telephone companies... Either a "UNIQUE WITH IGNORE DUPES" index must be used (comparitively very slow) or the dupes must be found and eliminated.
But I agree... this does sound like homework.
--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) -
What... and miss out on all that high-class entertainment?
--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)
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply