Calculate amount of mugs StackExchange should give away so I'll receive oneQuadtree implementationDesktop Notifications for flags and queue itemsJavascript Minesweeper (with Stack Snippets!)Impossibly fast delegate in C++11Lua OOP and classically-styled prototypal inheritanceImproving the Java UUID class performanceJAXB XJC code generation - adding @XmlRootElement and Joda DateTimeRecursion vs iteration of tree structureSIMD matrix multiplicationMatching a generated string of random letters to an inputC++ logging libraryIs it Friday yet?Asks the user to input 10 integers, and then prints the largest odd numberA first “Hangman” game in PythonProject Euler 001 in C++Password checker in PythonC++ Vector CloneSieve of Eratosthenes - PythonMy first random password generatorFIFO data structure in pure CClass for measuring distance as feet and inchesA Failable<T> that allows safe returning of exceptionsRepeatedly multiplying digits until a single digit is obtainedImplementing factory design pattern with genericsTryCast<T> methodCalculate a medianPHP Autoloader LibraryUnit-testing a controller in Ruby on RailsSandbox or safely execute evalLife is a Game - Play itFluent LinkedIn REST API client interface designExtensible loggingFishing simulatorCafé in C++ programFinding words of different lengths given six lettersBasic Java library to hold booksValidating opening and closing bracket pairsPython program to calculate GCDTape EquilibriumHow is my CMS design? Any security, design, or other issues?High performance txt file parsing1, 2, Fizz, 4, Buzz: FizzBuzzFormatter classLaw of Demeter and data models? What was the "5 minute EVA"? What was the shortest-duration EVA ever? Do Klingon women use their father's or mother's name? How do I figure out how many monomer configurations I need for my simulation? Did the Germans ever use captured Allied aircraft against the Allies? Can I assign any static IP to a device on my network? Or does it have to be within the DHCP servers (or routers) defined subnet? Python for OR: Which non-solver libraries do you use? mRNA-1273 vaccine: How do you say the “1273” part aloud? Is it normal to need to replace my brakes every few months? Equivalent of "So close!" How does the RJ45 crimping tool work? Netgear R6080 AC1000 Router throttling internet speeds to 100Mbps Should the stipend be paid if working remotely? Lights Out - finding worst initial state Help Stack Exchange transpose tables What does it mean when we say "Gravity is a source of gravity"? How would interspecies lovers with alien body plans safely engage in physical intimacy? What does it mean when an egg splatters and the white is greenish-yellow? Was "twelve" pronounced as "TPELF"? Is there any hope of getting my pictures back after an iPhone factory reset some day in the future? When should one recommend rejection of a manuscript versus major revisions? Upgrade tripod on a cheap telescope Sophisticated order to connect the poles for a jump start of the car battery Escaping backlash and double quotes inside a sed expression (surrounded by double quotes) Radioactive Decay, Gaussian or Uniform?

DECLARE @mugs INT,@rounded_mugs INT,@inc INT,@remainder INT;
SELECT  @mugs = COUNT(1) FROM Users WHERE Reputation >= 
  (SELECT Reputation FROM Users WHERE DisplayName='JaDogg');
SET  @remainder = @mugs%50;
IF (@remainder = 0) SET @inc = 0 ELSE SET @inc=50-@remainder; 
SELECT  @mugs+@inc AS 'AMOUNT OF MUGS TO GIVE AWAY';

WITH UserRanks AS (
    SELECT DisplayName
         , RANK() OVER (ORDER BY Reputation DESC) AS RepRank
        FROM Users
)
SELECT *, 50 * CEILING((RepRank + 0.0) / 50) AS BatchedRepRank
    FROM UserRanks
    WHERE DisplayName = ##Username:string##;

DECLARE @mugs INT;
DECLARE @rounded_mugs INT;
DECLARE @inc INT;
DECLARE @remainder INT;

SELECT  @mugs = COUNT(1) 
FROM Users 
WHERE Reputation >= (SELECT Reputation FROM Users WHERE DisplayName=##username:string?Community##);

SET  @remainder = @mugs%50;
IF (@remainder = 0) 
  SET @inc = 0 
ELSE 
  SET @inc=50-@remainder; 

SELECT  @mugs+@inc AS 'Amount of mugs to give away';