Sales.vSalesPersonSalesByFiscalYears
View: 'Sales.vSalesPersonSalesByFiscalYears', Uses PIVOT to return aggregated sales information for each sales representative.
Field Name
Type and Size
SalesPersonID
int NULL
FullName
nvarchar(152) NULL
Title
nvarchar(50) NOT NULL
SalesTerritory
Name NOT NULL
2002
money(19,4) NULL
2003
money(19,4) NULL
2004
money(19,4) NULL