title: How to calculate age in T-SQL with years, months, and days
body: <p>What would be the best way to calculate someone's age in years, months, and days in T-SQL (SQL Server 2000)?</p>
  
  <p>The <code>datediff</code> 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 <a href="http://en.wikipedia.org/wiki/Stored_procedure" rel="noreferrer">stored procedure</a>.</p>