Dataset: TopEmployees

CollapseAll image

Collapse image Dataset properties


 Property   Value 
 Data source name   AdventureWorks 
 Referenced data set    
 Command type   Query 

Collapse image Parameters


Name 
@ProductCategory
@ProductSubcategory
@StartDate
@EndDate
Total: 4 parameter(s)

Collapse image Fields


Name  Source column  Data type  Caption  Value  Is calculated field 
LastName LastName System.String      
FirstName FirstName System.String      
BusinessEntityID BusinessEntityID System.Int32      
SaleAmount SaleAmount System.Decimal      
FullName          
Total: 5 field(s)

Collapse image Filters


No filters exist

Collapse image Query


SELECT TOP 5 C.LastName, C.FirstName, E.BusinessEntityID, SUM(SOH.SubTotal) AS SaleAmount
FROM        Sales.SalesPerson SP INNER JOIN
            HumanResources.Employee E ON SP.BusinessEntityID = E.BusinessEntityID INNER JOIN
            Person.Person C ON E.BusinessEntityID = C.BusinessEntityID INNER JOIN
            Sales.SalesOrderHeader SOH ON SP.BusinessEntityID = SOH.SalesPersonID INNER JOIN
            Sales.SalesOrderDetail SOD ON SOH.SalesOrderID = SOD.SalesOrderID 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       (PC.ProductCategoryID = @ProductCategory) AND (PS.ProductSubcategoryID IN (@ProductSubcategory)) AND 
            (SOH.OrderDate > @StartDate) AND (SOH.OrderDate < @EndDate)
GROUP BY    C.LastName, C.FirstName, E.BusinessEntityID, PC.ProductCategoryID, PS.ProductSubcategoryID
ORDER BY    SUM(SOH.SubTotal) DESC

Collapse image See also


About this documentation