Counts how many edits to go before a person hits Strunk & White
Q&A for SharePoint enthusiasts
-- How Many Edits Until Strunk & White -- Counts how many edits to go before a person hits Strunk & White -- Edit the ID number to get your value DECLARE @UserId int = ##UserId## SELECT 100 - COUNT(*) AS 'Edits To Strunk & White' FROM Posts WHERE PostTypeId = 1 AND LastEditorUserId = @UserId AND OwnerUserId != @UserId