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

D Smith (1/9/2009)

---

The dress code issue is one near and dear to my heart. I've successfully lobbied to get dress codes changed to more casual ones at several places...

crussell (1/9/2009)

---

There comes a point when I look at someone dressed like a slob and think he probably programs like he dresses, doesn't pay much attention to detail. It may...

I believe that you need to dress to fit the situation. In my position, we wear casual business dress (dockers & polos) with jeans on Friday. However, regardless...

Similar to Sergio's solution, mine breaks down an age into quarterly periods (three months), also accounting for leap year, so partial ages can be compared:

ALTER FUNCTION [dbo].[fnCalcAge] (@DOB datetime, @CurrentDate...