AdventureWorks2019
Sales.vSalesPersonSalesByFiscalYears
//
Uses PIVOT to return aggregated sales information for each sales representative.
Created: Modified:
Columns
-
SalesPersonID[int] NULL
-
FullName[nvarchar](152) NULL
-
JobTitle[nvarchar](50) NOT NULL
-
SalesTerritory[Name] NOT NULL
-
2002[money] NULL
-
2003[money] NULL
-
2004[money] NULL
Definition
Sample Data
SalesPersonID
FullName
JobTitle
SalesTerritory
2002
2003
2004
NULL
NULL
NULL
275
Michael G Blythe
Sales Representative
Northeast
NULL
NULL
NULL
276
Linda C Mitchell
Sales Representative
Southwest
NULL
NULL
NULL
277
Jillian Carson
Sales Representative
Central
NULL
NULL
NULL
278
Garrett R Vargas
Sales Representative
Canada
NULL
NULL
NULL
279
Tsvi Michael Reiter
Sales Representative
Southeast
NULL
NULL
NULL
280
Pamela O Ansman-Wolfe
Sales Representative
Northwest
NULL
NULL
NULL
281
Shu K Ito
Sales Representative
Southwest
NULL
NULL
NULL
282
José Edvaldo Saraiva
Sales Representative
Canada
NULL
NULL
NULL
283
David R Campbell
Sales Representative
Northwest
NULL
NULL
NULL
284
Tete A Mensa-Annan
Sales Representative
Northwest
NULL
NULL
NULL
286
Lynn N Tsoflias
Sales Representative
Australia
NULL
NULL
NULL
288
Rachel B Valdez
Sales Representative
Germany
NULL
NULL
NULL
289
Jae B Pak
Sales Representative
United Kingdom
NULL
NULL
NULL
290
Ranjit R Varkey Chudukatil
Sales Representative
France