StackOverflowDocumentation
.dbo
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
usp_Q6856
Parameters
Name
Type
Mode
@MinReputation
int
IN
@Upvotes
int
IN
Definition
CREATE PROC [dbo].[usp_Q6856] @MinReputation INT, @Upvotes INT = 100 AS BEGIN /* Source: http://data.stackexchange.com/stackoverflow/query/6856/high-standards-top-100-users-that-rarely-upvote */ select top 100 Id as [User Link], round((100.0 * (Reputation/10)) / (UpVotes+1), 2) as [Ratio %], Reputation as Rep, UpVotes as [+ Votes], DownVotes [- Votes] from Users where Reputation > @MinReputation and UpVotes > @Upvotes order by [Ratio %] desc END