SQL Query to calculate Project Manager Planned Work Hours for 6 Months

[Pattro A.]

I am looking for a SQL query that will produce a matrixed table report with a 6 month look-ahead from current month, like this.   A Project Manager can have more than 1 project, and Project Manager has to be filtered from other resources within the RBS.

From Table 1   From Table 1     From Table 2

ResourceName: ProjectName  : PM HrsPlanned : Sept 2013: Oct2013 : Nov2013  : Dec 2013     T0TAL

Paul                  Install hardware           25           80                  75          40                  0                  250

Pete                  Decommissioning         20            60                 40           100               10               350

TOTAL                                               45           140                 115            140      10             600

[Author]

Posts