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...

gcopeland (1/9/2009)

---

I will say again for the n-th time that business and technical skills are concurrent. If you don't like this fact of business, then get yourself into academic...

gcopeland (1/9/2009)

---

GSquared (1/9/2009)

---

Couple of fallacies:

The way that Gates and Ballmer dress is considered socially appropriate for executives. It says nothing whatsoever about technical skill. You're concatenating two thoughts...

Ron Kunce (1/9/2009)

---

I've worn everthing possible in varying work environments, from formal tuxedo's, dress uniforms, suits, business casual (with or without ties), jump suits, fatigues, battle dress, dungarees, denim, underwear,...