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

I was trying to avoid that if possible because the entire SP relies on being in the correct database. If it's not possible to switch the database within an...