title: SQL: How to produce next date given month and day
body: <p>In my table I have a Month(tinyint) and a Day(tinyint) field.  I would like to have a function that takes this month and day and produces a datetime for the next date(including year) given this month and day.<br>
  <br>
  So if I had Month = 9, Day = 7 it would produce 9/7/2009. <br>
  If I had Month 1, Day 1 it would produce 1/1/2010.</p>