Q&A for enthusiasts and power users of the Android operating system
p.Id as [User Link],
substring(cast(Cast(Ranking as Decimal)/Count*100.00 as varchar), 1,6) + '%'
ROW_NUMBER() OVER(ORDER BY Reputation DESC) as Ranking
Users) as p,
(SELECT Count = COUNT(*)
) as Counts
Where p.Id = ##UserId##