ChildID WAIVER_SERVICES Month/Year services_provided Budget % used
10177 3 12/2012 125 125 100%
10177 3 1/2013 75 125 60%
10177 3 2/2013 100 175 57%
10177 9 1/2013 50 50 100%
10177 9 5/2013 800 950 84%
Looking at the last line of your desired output you have 800 for services_provided and 950 for Budget.
Using the tables and values you provided, how did you arrive at these 2 numbers?
__________________________________________________________________________________________________________
How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/