Q&A for professional and enthusiast programmers
-- How close are you to getting the Archaeologist badge? -- "Edited 100 posts that were inactive for 6 months" -- This is a rough estimate as the LastEditDate and LastActivityDate -- changes as soon as you edit the post DECLARE @UserId INT = ##UserId##; select top 10 * from posts --@UserId, --p.LastActivityDate, DATEADD(month, -6, p.LastEditDate) --from posts p --WHERE --p.LastActivityDate < p.LastEditDate --P.LastEditorUserId = @UserId --SELECT COUNT(*) FROM Posts p --WHERE p.LastActivityDate < DATEADD(month, -6, p.LastEditDate) --and P.LastEditorUserId = @UserId --and P.OwnerUserId != @UserId