Dataset: IndividualCustomerSales
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 |
| SalesOrderID | SalesOrderID | System.Int32 | |||
| TotalDue | TotalDue | System.Decimal | |||
| OrderDate | OrderDate | System.DateTime | |||
| CustomerID | CustomerID | System.Int32 | |||
| FirstName | FirstName | System.String | |||
| LastName | LastName | System.String | |||
| StateProvinceCode | StateProvinceCode | System.String | |||
| City | City | System.String | |||
| PostalCode | PostalCode | System.String | |||
| SpatialLocation | SpatialLocation | Microsoft.SqlServer.Types.SqlGeography |
Filters
Query
SELECT soh.SalesOrderID, soh.TotalDue, soh.OrderDate, c.CustomerID, p.FirstName, p.LastName, RTRIM(sp.StateProvinceCode) as StateProvinceCode, ad.City, ad.PostalCode, ad.SpatialLocation FROM Sales.SalesOrderHeader AS soh INNER JOIN Sales.Customer AS c ON soh.CustomerID = c.CustomerID INNER JOIN Person.BusinessEntity AS b ON b.BusinessEntityID = c.PersonID INNER JOIN Person.Person AS p ON p.BusinessEntityID = b.BusinessEntityID INNER JOIN Person.BusinessEntityAddress AS a ON a.BusinessEntityID = b.BusinessEntityID INNER JOIN Person.Address AS ad ON ad.AddressID = a.AddressID INNER JOIN Person.AddressType AS at ON at.AddressTypeID = a.AddressTypeID INNER JOIN Person.StateProvince AS sp ON sp.StateProvinceID = ad.StateProvinceID WHERE(c.PersonID IS NOT NULL) AND (at.Name = N'Home') AND (sp.CountryRegionCode = N'US') |
See also