Re: duplicates

That looks helpful. Thanks!

One question:
--Update temp table to add strAddress and dtmModified
UPDATE #tempduplicatedata
SET strAddress = tDupData.strAddress
,dtmModified = tDupData.dtmModified
FROM #tempduplicatedata
INNER JOIN tDupData
ON #tempduplicatedata.lngCompanyID = tDupData.lngCompanyID
AND #tempduplicatedata.strCompanyName = tDupData.strCompanyName

I don't see how this works. There would be multiple rows matching that
inner join. I would have thought that it would complain about that.

But it does work. Now, which row does it update from?

In the curent example, it looks like the last row. I expect that it is
undefined.

--
Thanks,
Brad.
"Arnie Rowland" <arnie@xxxxxxxx> wrote in message
news:OcGqQ3csGHA.3556@xxxxxxxxxxxxxxxxxxxxxxx
Bummer!

Here 'tis.

http://www.sql-server-performance.com/rd_delete_duplicates.asp

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

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


"Roy Harvey" <roy_harvey@xxxxxxxx> wrote in message
news:3ofic2dti9g27uonf5447b5ko0g6s5pc9n@xxxxxxxxxx
On Thu, 27 Jul 2006 15:01:09 -0700, "Arnie Rowland" <arnie@xxxxxxxx>
wrote:

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

Arnie, I think you forgot the link to the article.

Roy





.

Loading