Declare @StartDt Datetime
Declare @EndDt	 Datetime
Set @StartDt = '20090101'
Set @EndDt   = '20090131'
;with
 Sales (SalesRank, SalesPerson, TotSalesDollars)
as 
(Select	 SalesRank = Rank() over (order by sum(SalesDollars) Desc)
		,SalesPerson
		,sum(SalesDollars)
  from #SalesTbl
 Where SalesDate between @StartDt and @EndDt
   	  group by SalesPerson) --end of CTE
select	SalesRank
		,SalesPerson
		,TotSalesDollars
  from Sales
 where SalesRank <= 25

create table #SalesTbl(
			Salesperson char(30)
			,SalesDollars money
			,SalesDate datetime
			)
insert #SalesTbl 
Select 'Judy', 14554.22, '20090103' union All 
Select 'Judy', 15854.22, '20090103' union All 
Select 'Judy', 16554.22, '20090103' union All 
Select 'Joyce', 26554.22, '20090103' union All 
Select 'Ed', 25554.22, '20090103' union All
Select 'Andy', 24554.22, '20090103' union All 
Select 'Len', 22222.22, '20090103' union All
Select 'Tom', 22222.22, '20090103' union All
Select 'Maria', 4554.22, '20090103' union All
Select 'Chris', 6654.22, '20090103' union All
Select 'Tony', 4554.22, '20090103' union All
Select 'Sally', 4654.22, '20090103' union All
Select 'Bob', 4554.22, '20090103' union All
Select 'Bob', 4554.22, '20090103' 


Declare @StartDt Datetime
Declare @EndDt  Datetime
Set @StartDt = '20090101'
Set @EndDt   = '20090131'

Select top 5 with ties 
		 Salesperson
		,sum(salesDollars) TotSales
  from #SalesTbl
	Where SalesDate between @StartDt and @EndDt        
	group by SalesPerson
    order by sum(salesDollars) Desc

Salesperson                    TotSales
------------------------------ ---------------------
Judy                           46962.66
Joyce                          26554.22
Ed                             25554.22
Andy                           24554.22
Len                            22222.22
Tom                            22222.22

(6 row(s) affected)