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.aspxIntroduction: As part of the blog series TSQL - Solve it YOUR Way , today's topic will cover a question asked recently in the T-SQL MSDN forums where the solution, at first, seems extremely obvious. However, as solutions were proposed and flaws wereen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)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#10424488Fri, 07 Jun 2013 20:01:59 GMT91d46819-8472-40ad-a661-2c78acb4018c:10424488Naomi N<p>With some help found perfect solution here</p> <p><a rel="nofollow" target="_new" href="http://snipplr.com/view/18560/">http://snipplr.com/view/18560/</a></p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10424488" width="1" height="1">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#10424474Fri, 07 Jun 2013 18:27:58 GMT91d46819-8472-40ad-a661-2c78acb4018c:10424474Naomi N<p>Hi Sam,</p> <p>Can you please provide solution for C# and with fractional numbers? I need to calculate age with fractions.</p> <p>Thanks in advance.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10424474" width="1" height="1">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#10417418Thu, 09 May 2013 19:25:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:10417418MegaSQLBI<p>Thanks a lot for collecting together &amp; &nbsp;sharing, Sam!</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10417418" width="1" height="1">