Good day all - will start out by letting you know that my experience with SQL is limited to the most basic types of queries, generally run from VBA behind a user form. So I do apologize if this is simply ridiculous or if I'm not explaining it properly ...
I have a table, named News_Indexing_QA, which currently contains less than 20,000 records, but will be growing quickly. As part of the initial clean up, and as ongoing maintenance, I need to be able to identify and remove all but one record where others that are nearly identical exist. The columns that I can use to determine uniqueness are:
... In other words, the combined values of these two fields should only exist one time (ever).
Would any of you be kind enough to assist me with this? If it matters, I'm using Microsoft SQL Server Management Studio 2008 R2.
Thank you in advance for any guidance.