Samuel Lester, a senior tester in the SQL Server team is writting a blog series about how to solve common T-SQL problems in different ways. To that end, each entry in the series proposes a problem and then presents a few different approaches provided by different contributors.

There are many ways to approach a problem and the decision to pick a solution over another will probably depend on what you value most for a particular case. Are you looking to optimize performance, an elegant solution or perhaps all you need is a quick and dirty way to solve a problem that you won't see much more again?

This week's entry solves the frequent forum question of how to calculate a person's age based on their date of birth. I wrote a quick solution, and I encourage you to see the proposed answers. An interesting series indeed:

http://blogs.msdn.com/b/samlester/archive/2012/11/30/tsql-solve-it-your-way-finding-an-employee-s-current-age-based-on-birth-date.aspx