Jason Miller (4/3/2009)

---

I couldn't agree more. While it may be a pain to type in the "extra"...

I think it all comes down to a paradigm. Folks who spend most of their time in an object-oriented environment tend to think in those terms. The same...

My dad always told me that too much of anything, even a good thing, can be bad for you. I can't think of any example that is more applicable...

It's about 25 UDF/SP files and the dependencies are not always direct. While I really wanted to have a "click it and forget it" approach, I just may have...

That allows one to execute a SQL file from a .BAT file (requiring a connection to the database for each file), but what about within an existing SQL file that...

J (3/17/2009)

---

I strongly object to such obfuscated programming. How many beginners who subscribed to this forum could be misled into thinking "wow ! clever trick I've got to find an...

I agree with the earlier statement that the choice of a procedure named "GO" was a red herring. That has NOTHING to do with the GO separator. The procedure...

I think you're getting those scans because of the ISNULL clauses. You could try an OR where you check for each of the values independently, but that still might not...

The 697 is more correct. Dave posted the...

Thanks for the explanation. Apparently, recalculating the statistics did wonders. The function executes now!! :w00t:

Still, I'm going to investigate the index issue. While SourceID is indeed on...

I can certainly see your concern about this:

WHERE R.MedGroupID = ISNULL(@MedGroupID, R.MedGroupID)

But I'm not sure what else I can do to allow the MedGroupID to be specified yet if it's...

The commented lines are what I used to change it from an inline UDF to a multi-line UDF. You're correct in that it did not solve the problem, so...

I investigated the possibility of parameter sniffing, so I changed the function from an Inline Function to a multi-line function yet the problem persists. I've attached the code for...

It is indeed an inline statement that contains 3 CTEs and a final query referencing the CTEs. As I mentioned, when I pull the code out to a separate...

Brian,

It's an interesting approach and one that I wish I could use, however this doesn't allow me to establish conditional matching as well. Therefore, I'm attempting to do record...