I think i will go with http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

thanks, guys!

I'll try it. thanks.

update SHIP_BOL_HDR

SET [3rdPartyAddress] = REPLACE ( [3rdPartyAddress],'' ,'' )

I guess it does. Well, imagine that the first set of single quotes you see above are the ones...

steveb (7/22/2009)

---

middletree (7/22/2009)

---

When I posted the message, it included the bad stuff. But this forum stripped it out, which is understandable. It was an HTML script tag, followed by a...

When I posted the message, it included the bad stuff. But this forum stripped it out, which is understandable. It was an HTML script tag, followed by a link to...

I tried this and it didn't work:

update SHIP_BOL_HDR

SET 3rdPartyAddress = REPLACE ( 3rdPartyAddress ,'' ,'' )

The error just said nothing helpful.

OK, I just ran it against the 2005 version of this thing. It removed the expected number of rows. Now I'll check it out in detail.

thanks very much

Oh geez. I am dealing with two database servers here. One is Win2000/SQL2000, the other being Win2003/SQL2005. I'm moving from one to the other. In fact, that's the point of...

I also ran it with the semicolon, got a similar error.

To be clear, this is what I have in the query window in SSMS. Nothing else. Just the text between...

I chose those two fields (PartNo and Version) because they are, effectively, the PKs. That is, they aren't defined as such, but those are the two fields together I want...

OK, I tried running it. Here's the altered code:

=============

WITH cteDupes AS

(

SELECT

ROW_NUMBER() OVER(PARTITION BY PartNo,...

I didn't run it because by reading it, it appeared that it required an ID column or PK.

Anyway it's on SQL 2005; here's the create statement:

USE [RICCA]

GO

/****** Object: ...

OK, I just checked out the code, and it appears that while the snippet posted above will enable me to remove dupes from the table in that sample, I couldn't...

Sadly, the people responsible for this are no longer here. I'm a web developer getting a crash course to become a DBA 😉

thanks. I think I can work with this....