0

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

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
  *
FROM
    Users
WHERE
        CreationDate  > @startDate
    AND Reputation    > @reputation

view current version

edited jul 9 12

created jul 9 12 ThinkingStiff