Sales vSalesPerson (view)

Modified on 2011/08/27 11:19 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''View'''
| Sales.vSalesPerson
|- valign="top"
| '''Description'''
| Sales representiatives (names and addresses) and their sales-related information.
|}

=== Source ===
{{{{<nowiki>
CREATE VIEW [Sales].[vSalesPerson] 
AS 
SELECT 
    s.[SalesPersonID]
    ,c.[Title]
    ,c.[FirstName]
    ,c.[MiddleName]
    ,c.[LastName]
    ,c.[Suffix]
    ,[JobTitle] = e.[Title]
    ,c.[Phone]
    ,c.[EmailAddress]
    ,c.[EmailPromotion]
    ,a.[AddressLine1]
    ,a.[AddressLine2]
    ,a.[City]
    ,[StateProvinceName] = sp.[Name]
    ,a.[PostalCode]
    ,[CountryRegionName] = cr.[Name]
    ,[TerritoryName] = st.[Name]
    ,[TerritoryGroup] = st.[Group]
    ,s.[SalesQuota]
    ,s.[SalesYTD]
    ,s.[SalesLastYear]
FROM [Sales].[SalesPerson] s
    INNER JOIN [HumanResources].[Employee] e 
    ON e.[EmployeeID] = s.[SalesPersonID]
    LEFT OUTER JOIN [Sales].[SalesTerritory] st 
    ON st.[TerritoryID] = s.[TerritoryID]
    INNER JOIN [Person].[Contact] c 
    ON c.[ContactID] = e.[ContactID]
    INNER JOIN [HumanResources].[EmployeeAddress] ea 
    ON e.[EmployeeID] = ea.[EmployeeID] 
    INNER JOIN [Person].[Address] a 
    ON ea.[AddressID] = a.[AddressID]
    INNER JOIN [Person].[StateProvince] sp 
    ON sp.[StateProvinceID] = a.[StateProvinceID]
    INNER JOIN [Person].[CountryRegion] cr 
    ON cr.[CountryRegionCode] = sp.[CountryRegionCode];
</nowiki>}}}}

=== References ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type'''
| '''Object Type'''
| '''Referenced Object'''

|- valign="top"
| Select
| Table
| [[HumanResources Employee (table)|HumanResources.Employee]]

|- valign="top"
| Select
| Table
| [[HumanResources EmployeeAddress (table)|HumanResources.EmployeeAddress]]

|- valign="top"
| Select
| Table
| [[Person Address (table)|Person.Address]]

|- valign="top"
| Select
| Table
| [[Person Contact (table)|Person.Contact]]

|- valign="top"
| Select
| Table
| [[Person CountryRegion (table)|Person.CountryRegion]]

|- valign="top"
| Select
| Table
| [[Person StateProvince (table)|Person.StateProvince]]

|- valign="top"
| Select
| Table
| [[Sales SalesPerson (table)|Sales.SalesPerson]]

|- valign="top"
| Select
| Table
| [[Sales SalesTerritory (table)|Sales.SalesTerritory]]

|- valign="top"
| Schema
| Schema
| [[Sales (schema)|Sales]]

|}
devio dbscript ScrewTurn Wiki

Navigation¶

Sales vSalesPerson (view)
