TSQL Challenge 64 - A Payroll calculation Challenge
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays
http://beyondrelational.com/puzzles/challenges/98/a-payroll-calculation-challenge.aspx