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 about the site for serious players and enthusiasts of chess
-- How much reputation are you getting from your past work? -- 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 declare @UserId int = ##UserId##; SELECT @UserId AS [User Link], @UserId AS Id, Reputation, AgeInDays AS AccountAgeInDays,CAST(CAST(RepFromPast AS float)/AgeInDays AS int) AS OldReputationPerDay FROM ( SELECT @UserId AS Id, SUM(Reputation) AS RepFromPast FROM ( SELECT CASE WHEN VoteTypeId = 2 THEN 10 ELSE -2 END AS Reputation 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 AND p.ownerUserId != parents.ownerUserId ) AS RepCounts ) As RepAndUserCount JOIN ( SELECT Id, Reputation, CONVERT(int, GETDATE() - CreationDate) as AgeInDays FROM Users WHERE Users.Id = @UserId ) AS AccountAge ON RepAndUserCount.Id=AccountAge.Id