Progress towards editor badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

Determines how many edits remain before achieving the Editor, Strunk and White and Copy Editor badges

Stack Overflow

Q&A for professional and enthusiast programmers

-- Progress towards editor badges
-- Determines how many edits remain before achieving the Editor, Strunk and White and Copy Editor badges

DECLARE @UserId int = ##UserId##

DECLARE theSelect CURSOR FOR
  SELECT
    COUNT(*)
  FROM
    Posts
  WHERE
    (PostTypeId = 1 OR PostTypeId = 2)
    AND LastEditorUserId = @UserId
    AND OwnerUserId != @UserId
OPEN theSelect

DECLARE @TotalEdits int
DECLARE @EditsRemainingUntilEditor int
DECLARE @EditsRemainingUntilStrunkAndWhite int
DECLARE @EditsRemainingUntilCopyEditor int

FETCH NEXT FROM theSelect into @TotalEdits

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results