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

  • This topic has 0 replies, 1 voice, and was last updated 9 years ago by Pattro A..
Viewing 1 post (of 1 total)
  • Author
    Posts
  • #30211
    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)
  • You must be logged in to reply to this topic.