I checked the data and with the business source and was able to determine that the value will never be null. I removed the ISNULL and the problem went...

ISNULL(Patient_Primary_Policy_Carrier_ID,-1) AS Primary_Policy_Carrier_ID,

Now that I look at it more closely, I'm not surprised that this is the line. It appears to be an order of execution thing as this...

I'll do that and let you know what happens.

That works fine so you're right, there's something subtle but I can't pinpoint it.

I tried moving the searched case to the top of the SELECT just to see if that...

In every case, the query properly branched to 'Branch 1' when Patient_Primary_Policy_carrier_id = -1. Here's the entire query where the searched case is NOT working properly. Maybe you'll...

Thanks. I've got the query working but I'm out of time to do the analysis. I will get back to it either later tonight or in the morning...

I didn't code this but I'm trying to maintain it. The field is an integer so I got rid of the quotes around the '-1' on the off chance...

Eddie Hendrix (11/20/2009)

---

if your on a 64 bit system, and 64-bit SQL, you don't need to worry about any of this AWE, "lock pages in memory" stuff. 64-bit is...

Just to clarify. If you're using 64-bit SQL Server it is recommend that Lock Pages in Memory be enabled and that the AWE enabled switch be set. This...

I was a "double red" donor for several years and a blood donor for 15 years. Unfortunately, I had a little encounter with Mr. Cancer so I'm not allowed...

Thanks for the explanation. I understand it now. (I'm also glad that I don't have to do this. :-D)

James Rochez (10/23/2009)

---

Seth Lynch (10/23/2009)

---

Robert Frasca (10/23/2009)

---

I don't understand the "Book[Price < 4 ]"component. Shouldn't that mean that "<Name>book4</Name> " should NOT have been returned since the price of...

I don't understand the "Book[Price < 4 ]"component. Shouldn't that mean that "<Name>book4</Name> " should NOT have been returned since the price of book 4 = 4?

I think it depends on your definition of DBA. (We can debate this endlessly.) You don't need any previous technical experience to perform backups, monitor servers and jobs...

So it just ignores the FG2 reference? The fact that it essentially corrects the developer's mistake is great, I guess, but shouldn't the engine inform the developer that it's...