Well taking the exact same example I originally used and replacing the ROW_NUMBER function with rank as below

WITH Leaderboard AS

(SELECT FirstName + ' ' + Surname AS Player, ShotsTaken AS...

Ah, makes sense using RANK. Cheers Chris.

From what I understand you specify the order by to use - using an example similar to what I've seen

WITH Leaderboard AS

(SELECT FirstName + ' ' + Surname AS...

Thanks for taking the time to give feedback Mike (and Jack), it helps to have a better idea of whats going on behind the scenes.

So I gather that the...

Hi Mike, thanks for your input.

I've changed the WHERE clause now as a matter of course, but out of interest I ran both queries on exactly the same data using...

Thanks for the comment Jack.

I used isnull/coalesce here because I had to consider both NULLs and empty string values owing to how different processes update this table.

As it happens I...

Sorry if this has already been covered but after reading 6 pages of unconstructive criticism by cimode I couldn't take any more.

Regarding Rule 4, I had an issue when using...

Sorry if this has already been covered but after reading 6 pages of unconstructive criticism by cimode I couldn't take any more.

Regarding Rule 4, I had an issue when using...