Generated using SQL Data Dictionary demo version.
Uses PIVOT to return aggregated sales information for each sales representative.
| Column | Data Type | Nullable |
|---|---|---|
| SalesPersonID | int | X |
| FullName | nvarchar(152) | X |
| JobTitle | nvarchar(50) | |
| SalesTerritory | Name(nvarchar(50)) | |
| 2002 | money | X |
| 2003 | money | X |
| 2004 | money | X |