-- EmployeeSalesSummary_EmpSalesDetail

SELECT      C.FirstName + ' ' + C.LastName AS Employee, 
            DATEPART(Month, SOH.OrderDate) AS OrderMonthNum, 
            PS.Name                        AS SubCat, 
            SUM(SOD.LineTotal)             AS Sales, 
            SOH.SalesOrderNumber, 
            P.Name                         AS Product, 
            SUM(SOD.OrderQty)              AS OrderQty, 
            SOD.UnitPrice, 
            PC.Name                        AS ProdCat

FROM        Sales.SalesOrderHeader        SOH 
INNER JOIN  Sales.SalesOrderDetail        SOD ON SOH.SalesOrderID       = SOD.SalesOrderID 
INNER JOIN  Sales.SalesPerson             SP  ON SOH.SalesPersonID      = SP.BusinessEntityID 
INNER JOIN  HumanResources.Employee       E   ON SP.BusinessEntityID    = E.BusinessEntityID 
INNER JOIN  Person.Person                 C   ON E.BusinessEntityID     = C.BusinessEntityID 
INNER JOIN  Production.Product            P   ON SOD.ProductID          = P.ProductID 
INNER JOIN  Production.ProductSubcategory PS  ON P.ProductSubcategoryID = PS.ProductSubcategoryID 
INNER JOIN  Production.ProductCategory    PC  ON PS.ProductCategoryID   = PC.ProductCategoryID

WHERE       (DATEPART(Year,  SOH.OrderDate) = @ReportYear) 
AND         (DATEPART(Month, SOH.OrderDate) = @ReportMonth) 
AND         (SOH.SalesPersonID = @EmpID)

GROUP BY    C.FirstName + ' ' + C.LastName, 
            DATEPART(Month, SOH.OrderDate), 
            SOH.SalesOrderNumber, 
            P.Name, 
            PS.Name, 
            SOD.UnitPrice, 
            PC.Name