Source code SQL 2005 Adventure Works OLTP

Territory Sales Drilldown


/* ***** Source for query:  TerritorySales ***** */
 
SELECT      ST.Name, SP.SalesPersonID, 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.SalesPersonID = E.EmployeeID INNER JOIN
            Person.Contact C ON E.ContactID = C.ContactID INNER JOIN
            Sales.SalesOrderHeader SOH ON SP.SalesPersonID = SOH.SalesPersonID
GROUP BY    ST.Name, SP.SalesPersonID, C.FirstName, C.LastName, SOH.SalesOrderNumber, SOH.TotalDue
ORDER BY    ST.Name

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.