A question where every coder/DBA/QA and Tester should now about
Saved Stories
- What are the advantages of the demat account?
- Tell us about the last time you lost your temper? Did you take personal accountability for this situation?
- What is GAAP? Name at least three of the principles
- Can a Silverlight application create or change Office Documents via Open XML?
- How would you sort a linked list?
Sponsored Categories
In short:
1. Select the duplicate key values into a holding table
2. Select the duplicate rows into a holding table, eliminating duplicates in the process
3. Delete the duplicate rows from the original table
4. Put the unique rows back in the original table
Here is step-by-step answer from Microsoft
http://support.microsoft.com/kb/139444