How to calculate age in TSQL with Years, Months, and Days
What would be the best way to calculate someone's age in years, months, and days in TSQL (SQLServer 2000)?

The datediff function doesn't handle year boundaries well, plus getting the months and days separate will be a bear.  I know I can do it on the client side relatively easily, but I'd like to have it done in my sproc.
How to calculate age in TSQL with Years, Months, and Days
===

What would be the best way to calculate someone's age in years, months, and days in TSQL (SQLServer 2000)?

The datediff function doesn't handle year boundaries well, plus getting the months and days separate will be a bear.  I know I can do it on the client side relatively easily, but I'd like to have it done in my sproc.