The Sales. VSalesPersonSalesByFiscalYears view in the AdventureWorks sample database uses PIVOT to return the total sales for each salesperson, for each fiscal year.

• AdventureWorks示例数据库中的Sales.；vSalesPersonSalesByFiscalYears视图将使用PIVOT返回每个销售人员在每个会计年度的总销售额。