Dataset: TerritorySales
Dataset properties
| Property | Value |
| Data source name | AdventureWorks |
| Referenced data set | |
| Command type | Query |
Parameters
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 |
Filters
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 |
See also