1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Users by Name
-- DisplayNameLike: Enter '%Robert%' (including single quotes) to find users named Robert.

select top 1000
  id as [User Link],
  round((100.0 * (Reputation/10)) / (Upvotes+1), 2) as [Ratio %],
  Reputation as Rep, 
  UpVotes as [+ Votes],
  DownVotes [- Votes],
  Location,
  AboutMe,
  LastAccessDate
from Users
where (DisplayName like ##DisplayNameLike##)
order by [DisplayName] asc

fork query

edited mar 28 12

created mar 28 12 Robert Claypool