As in the title. Depends on what people type into the country description.
Q&A for programmers
-- Are you one of the top SO-users in your country or state?
-- As in the title. Depends on what people type into the country description.
declare @MyRep int;
declare @UserId int;
SET @UserId = ##UserId##;
SELECT @MyRep = reputation
WHERE id = @UserId
SET @MyRep = 0;
ROW_NUMBER() OVER (ORDER BY reputation DESC),
id as [User Link],
where location like '%##country##%'
AND reputation >= @MyRep
order by reputation desc