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