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

This is a variant of the version that I use. I've modified it to use the same arguments as the one given in the article. I liked the...

Thanks, I'll look into it. I did find that I can create a table of entries of all rule children (tests and rules) using a recursive CTE. That...

I know that a CTE is only used in the following statement, but in this case I have 2 CTE's defined (the 1st feeding the 2nd). The INSERT statement...

I realize that it's quite local, but the problem I have is that within the CTE is a recursive call to the same UDF that has the CTE. Therefore,...

I just did and you wouldn't believe what I discovered! :hehe: Apparently, if the SP begins with anything else other than "sp_", then I can't run it in...