0

Please login or register to vote for this query.

(click on this box to dismiss)

This script counts the number of others' posts on which you have edited either the title or body.

Q&A for professional and enthusiast programmers

-- How many posts have I edited (for badges)?
-- This script counts the number of others' posts on which you have edited either the title or body.
Declare @UserId int = ##UserId##
select count(distinct p.Id) as 'Posts Edited'
from PostHistory h, Posts p where
h.UserId=@UserId and p.Id=h.PostId and p.OwnerUserId!=@UserId and
h.PostHistoryTypeId in (4,5,24)

fork query

edited dec 25 12

created dec 24 12 robjohn