What is my overall rank compared to other users and which user page am I on.
Q&A for SharePoint enthusiasts
-- How do I Rank Compared to Other Users -- What is my overall rank compared to other users and which user page am I on. declare @UserId int = ##UserId## select (count(*) + 1) as Rank, ((count(*) / 35) + 1) 'User Page', (select reputation from users where id = @UserId) Reputation from users where reputation > (select u.reputation from users u where u.id = @UserId)