Execute the following SQL Server T-SQL script in SSMS Query Editor to list YTD and Last Year sales by rep:

USE AdventureWorks2008;

SELECT row_number()

         OVER(PARTITION BY CountryRegionName ORDER BY SalesYTD ASC) AS SeqNo,

       CountryRegionName,

       FirstName,

       LastName,

       JobTitle,

       SalesYTD = '$' + convert(VARCHAR,SalesYTD,1),

       SalesLastYear = '$' + convert(VARCHAR,SalesLastYear,1)

FROM   Sales.vSalesPerson