How do I implement a "SELECT DISTINCT" equivalent?

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

Hi.

I have a dataset which is the result of a merge operation from several
source datasets (via the Merge method). Problem is that I dont control the
source datasets and I need to ensure that I dont get duplicate results in
the final (merged) dataset. I have a primary key on a columns on the tables
in all datasets so I can enforce a constraint on that. However, I want to
prune the results of duplicates, rather than failing outright. Effectively,
I want the equivalent of a "SELECT DISTINCT" SQL statement.

How do I do this? How do I quickly prune duplicate results to return only
distinct rows?

Thanks!

-Danny-
 
Back
Top