Indeed, that's the way to do it.

Also when adding the alert, make sure you're notified (extra) because it may point you to "unexpected" high volume of activity.

check this forum : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1433118&SiteID=1

So you mean that requester is blanc if it is note equal to alias ?

;with cteMPVAliasByRank (Ranking, Alias, Country, Yearmonth, PrizeAmount

I try to write slow, for those who cannot read fast

Seriously, today has been one of the few...

- Good point Jeff

- Also check what kind of transaction isolation level is used for the connection and / or command ! And...

No problem, just add the highlighted 

;with cteMPVAliasByRank (Ranking, Alias, Country, Yearmonth, PrizeAmount)

as

indeed, that's a little confusing flaw in my code part.

As you can see my first code post, I'd updated it before you replied....

btw the most common use of CTE's is as a replacement for nested table expressions.

In many cases in join operations, CTE's will outperform repeated nested table expressions.

Check BOL or SSC

Can CTE's be used within a Stored Procedure?

Yes they can !

CTE's are new with Tsql in SQL2005. Search BOL or SSC  for more...

So this is on SQL2005 ?

Try this new CTE :

-- replaced your persistent table to #temptb just for testing

create

table #tblMPVLeaderBoard(

LeaderBoardID int,

Yearmonth...

- Check that the @SITEID is defined exactly as is your column SiteFK in your table Clients. This way you avoid implicit conversions, which may cause your index not being...

With your top-clause, sqlserver ends the search for rows when the top-number is reached.

So if the top-number hasn't been reached, the quest goes on !

Because your plan shows...

Keep in mind it is not needed for SQLServer to have a domainadmin privileged service account !! (Huge risk !!)

Keep in mind it is not needed for SQLServer to have...

- yes

- read the (inside) books, play, test

- test, test, test, play

- follow some good forums like SSC

learn to play, play to learn

And if you...

I second that, GilaMonster  !

You may be better of putting some effort into analysing top-x predicate combinations and providing good accesspaths for...