SDU Tools 149 Calculate Age in Months in SQL Server T-SQL
SDU Tools are free tools and example T-SQL code for SQL Server developers and DBAs. This is a tool that you would not think was needed, as T-SQL includes DATEDIFF. But can you use DATEDIFF to determine someone's age? Surprisingly, no. This tool takes care of the issue.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com