Let me see if I understand your situation correctly.

You want to update A, B & C when none of these columns equal the A, B, and C columns from another...

Kath,

Thank you for adding your insight. I think only one of the previous respondents works with HL7, so your perspective is very welcome indeed.

Ah, okay. I thought your post before last was a "I still need help" kind of post. That's why I asked if you were going to do that in your...

Is that really what you are going to be doing with your code?

Gilligan

It does. Just so long as you're aware of your particular needs and code it so that it doesn't use an existing value, you should be able to use it...

Yes, I'm aware of that issue. I should have been more clear in my earlier reply.

When using ISNULL() this way, you need to make sure you're using a new value...

Ahha!

Thanks, guys.

zapouk (7/21/2011)

---

....

declare @B1 char(1) --could be null

declare @B2 char(1) --could be null

....

select @B1 = 'x'

select @B2 = null

....

@B1 = @B2

....

select @B1 = null

select @B2 = null

...

@B1 = @B2

--Ans:...

Philip Yale-193937 (7/21/2011)

---

Brandie Tarvin (7/20/2011)

---

This code will most likely NOT use the index because the index only works if your WHERE clause has Col3 listed and if it references Col3...

I'm curious. How many people subscribe to a job service (or keep in touch with job sites / recruiters) because they're currently looking?

Or do you just keep in touch just...

Gidget

That salary can't be...

Oi! That...

We do not have enough information to fully answer your questions. We would need create table statements, create index statements, and sample data insert statements in order to test ourselves....