Skip to content

Query: SubQry Rpt EP Counts by Principal Project Delivery Location

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects

Columns Selected

  • vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.[Principal Project ID
  • vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.[Company Delivery Loc
  • Sum(vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.[Allocated Weight

SQL

SELECT vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.[Principal Project ID, vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.[Company Delivery Loc, Sum(vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects.[Allocated Weight FROM [vwGarnetCurrentOnProgEPsbyDeliveryLocwithPrincipalProjects]