Just one note - for MonthsInService using that calculation are you aware that this will give you a value of 1 month even though there is only one day difference?
DATEDIFF(month, '20091231', '20100101')
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs