Re: duplicates

Here's a good article about how to remove duplicates. Hopefully, it will
provide you all the information you need.

Good luck on your project.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Brad White" <bwhite at inebraska . com> wrote in message
news:eZwg0WcsGHA.1272@xxxxxxxxxxxxxxxxxxxxxxx
"Brad White" <bwhite at inebraska . com> wrote in message
news:%23Sp1q%23bsGHA.3496@xxxxxxxxxxxxxxxxxxxxxxx
I have many occurances of two rows that have the same ID.
How to select just one of each?
I can copy into a temp table, and add an identifier of some kind.
But I don't know what to use for an identifier.


I could select distince on the ID into a temp table, but
I don't see how that helps me get one copy of the original
data out.

I can't select distinct on the original data.
"The text, ntext, or image data type cannot be selected as DISTINCT."

--
Thanks,
Brad.



.

Loading