Hehe... thanks for all your help, the slimming down of this query has really sped up the results. Now all that is left...

that is exactly what I was trying to do... Thanks for all the help. Just one thing though, you need to prefix the cast columns with M. otherwise it gives...

Thanks alot, that works, but it fills every row with that statement, which isn't exactly what i want. I'll explain...

I want it only to mark the person who has requested...

@ Jeff: Thanks, I have just tested it and it works without the min statement.

@ ALZDBA: I will definitely look into BOL and SSC, but I have one last thing...

Thanks for the heads up on CTE... Much easier than my previous query and much faster when i tested it on the real table.

Here is the new stored procedure which...

excuse my ignorance... I am new to SQL Server.

Yes this is SQL Server 2005.

Can CTE's be used within a Stored Procedure? It works fine within SQL Server Management Studio if...

tblMPVLeaderBoard - is the main table that the data is taken from

and the create statement for that is

create table tblMPVLeaderBoard(

LeaderBoardID int,

Yearmonth varchar(50),

Alias nvarchar(40),

Country varchar(50) int,

PrizeAmount decimal(10,2)

)

and the insert statement...

Hi John.

I was able to come up with something that works exactly the way I need, but I think that it may be very server intensive if many people are...