Being Scientific About It

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @UserName nvarchar(40) = '##DisplayName##';

DECLARE @jonsScore int;
DECLARE @yourScore int;
DECLARE @milliSkeets float;

SELECT @jonsScore = (SELECT Reputation FROM Users WHERE Id = 22656);
SELECT @yourScore = (SELECT TOP 1 Reputation FROM Users WHERE DisplayName = @UserName);
SELECT @milliSkeets = (CAST(@yourScore AS FLOAT) / CAST(@jonsScore AS FLOAT) * 1000);

PRINT @UserName + ' is ' + LTRIM(Str(@milliSkeets, 25, 5)) + ' milliskeets'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results