0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and scholars of mythology and folklore

DECLARE @startDate AS DATETIME2
DECLARE @reputation AS INT

SELECT
  @startDate = CreationDate,
  @reputation = Reputation
FROM
  Users
WHERE
  Id = '##UserId##'
  
SELECT
    COUNT(*)          AS [Total Users]
FROM
    Users
WHERE
        CreationDate  > @startDate
    AND Reputation    > 200

SELECT
  COUNT(*) + 1         AS [My Rank]
FROM
    Users
WHERE
        CreationDate  > @startDate
    AND Reputation    > @reputation

SELECT
    DisplayName,
    Reputation,
    CreationDate
FROM
    Users
WHERE
        CreationDate  > @startDate
    AND Reputation    > @reputation
ORDER BY 
    Reputation        DESC
    
SELECT
    DisplayName,
    Reputation,
    CreationDate
FROM
    Users
WHERE
        CreationDate  > @startDate
    AND Reputation    > @reputation
ORDER BY 
    CreationDate      DESC

fork query

edited jul 9 12

created jul 9 12 ThinkingStiff