I want the SQL SELECT statement to extract information from the MS SQL database behind MS Project Server. This will require SQL knowledge along with knowledge of the MS Project database. I want to extract the forecasted amounts of work by project for resources in MS Project for the next four weeks. The weeks end on Friday. The attached Excel spreadsheet gives an idea of the format that I expect the data to be returned. Having the sub-total lines is optional as I can pull the data to Excel and sub-total there.
Note: I am only looking for a SQL statement. I don't need a program or anything complex. Successful completion may bring on additional SQL query requests.