Dataset: TerritorySales

CollapseAll image

Collapse image Dataset properties


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

Collapse image Parameters


No parameters exist

Collapse image Fields


Name  Source column  Data type  Caption  Value  Is calculated field 
Name Name System.String      
BusinessEntityID BusinessEntityID System.Int32      
FirstName FirstName System.String      
LastName LastName System.String      
SalesOrderNumber SalesOrderNumber System.String      
TotalDue TotalDue System.Decimal      
Total: 6 field(s)

Collapse image Filters


No filters exist

Collapse image Query


SELECT      ST.Name, SP.BusinessEntityID, C.FirstName, C.LastName, SOH.SalesOrderNumber, SOH.TotalDue
FROM        Sales.SalesTerritory ST INNER JOIN
            Sales.SalesPerson SP ON ST.TerritoryID = SP.TerritoryID 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
GROUP BY    ST.Name, SP.BusinessEntityID, C.FirstName, C.LastName, SOH.SalesOrderNumber, SOH.TotalDue
ORDER BY    ST.Name

Collapse image See also


About this documentation