4

Please login or register to vote for this query.

(click on this box to dismiss)

Take the "unexpected" reputation coming from your answers from last month. Suppose now you constantly get those, and figure out how much rep per day you are getting for your past work without "working for it" on that given day

Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition

-- Collecting votes from the past
-- This query will look for answers that got upvoted more than a month after they were posted

declare @UserId int = ##UserId##;

SELECT
    parents.Id AS [Post Link], p.creationDate AS PostDate, v.CreationDate AS VoteDate 
FROM
    Votes v JOIN Posts p ON v.PostId=p.Id JOIN Posts parents ON p.ParentId=parents.Id
WHERE
    p.PostTypeId = 2
 AND
    p.OwnerUserId = @UserId
 AND
    v.VoteTypeId In (2,3)
 AND
    datediff(day, p.CreationDate,v.CreationDate) > 30

view current version

edited jul 7 12

created jul 7 12 Miquel