Nice one Cadavre!

That's the same collation issue that I was trying to address the other day when timing REPLACE on another thread.

Just one question though. Did Jeff Moden put...

vinu512 (6/20/2012)

---

Very Nice Dwain.

I can swear by anything right now that we are thinking the same stuff.

I was working something like the query you posted and as soon as i...

Jacobs_r86 (6/20/2012)

---

Thanks dwain, found the problem (which I would have found a lot quicker if I took note of your first reply in relation to primary keys). There were 2...

You know, when I first saw this thread I figured Lynn had nailed it.

But then Vinu, you posted these questions and I reread the OP's original statement. If your...

I don't know. But this gives you a result set with no column headers:

SELECT 123, 456

Jacobs_r86 (6/20/2012)

---

I see what you mean and it makes sense but there were 39 records that got updated out of the possible 40. It looks to be failing on 'c2.ClientName...

No harm done. Seems we're frequently racing.

vinu512 (6/19/2012)

---

Thank you very much Dwain. I got to understand almost all of it. But the only thing I don't understand is that I can get the results using the...

wendy elizabeth (6/19/2012)

---

Can you tell me if the [AT_id] in the [dbo].[AT_Pln] is a foreign key to the [dbo].[AT] table? To me it looks like there is no foreign key...

I'm not 100% sure of your question, but I see at least 3 issues here. First, your DDL and setup data is wrong (you're not INSERTing anything into @temp2),...

Jacobs_r86 (6/19/2012)

---

Thanks dwain, that looked to work... somewhat. I just ran some checks and it missed one, or rather it seemed to 'ZZ' its entry in the c2 referenced table...

Let me add a couple of steps, because I realized I left something vital out:

4) So you see, the STUFF is really something like this:

STUFF( (subquery), 1, 1, '')

5)...

Vinu,

OK, let's give the whole thing a shot step by step:

1. Here's an example of STUFF - it returns 'DEF' by stuffing an empty strings into positions 1-3.

SELECT STUFF('ABCDEF', 1,...

Jacobs_r86 (6/19/2012)

---

Yes thats correct some of the clients have been terminated correctly with the 'ZZ ' appended, so I want to azoid 'ZZ ZZ 'ing them.

And the 'ClientName' field isn't...

Oops sorry. Wrong answer.