Loading...
Quick Links

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

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

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #30211 Reply
    Pattro A.
    Guest

    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

Viewing 1 post (of 1 total)
Reply To: SQL Query to calculate Project Manager Planned Work Hours for 6 Months
Your information: