mtillman-921105 (7/25/2011)

---

Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic SQL Master"...

halifaxdal (7/25/2011)

---

Brandie Tarvin (7/25/2011)

---

What sort of problems are you having with it? If you post detailed problem descriptions / error messages, we...

What sort of problems are you having with it? If you post detailed problem descriptions / error messages, we might be able...

Movie title. "Despicable Me."

zapouk (7/22/2011)

---

Sorry, haven't got access to my sql code at the moment but the example I've given matches it. The only nullable column is A and it's a one-to-one relationship...

I love chapter 2, The First Programmer was a Lady.

Me

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.