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: