0

Please login or register to vote for this query.

(click on this box to dismiss)

You need 500 edited posts to get 'Copy editor' badge and 80 edits to get 'Strunk & White' badge

Q&A for enthusiasts and scholars of mythology and folklore

DECLARE @user INT = ##UserId:int##
DECLARE @edits INT

select
    @edits=COUNT(*)
FROM PostHistory
LEFT JOIN Posts as Post on PostHistory.PostId=Post.Id
WHERE UserId=@user and Post.OwnerUserId!=@user
AND PostHistoryTypeId in (4,5)

SELECT
    @edits,
    CAST(ROUND(@edits * 1.25, 2) as VARCHAR(10)) + '%' as StrunkAndWhite
    --CAST(convert(numeric(5,2), @edits / 5.0) as VARCHAR(10)) + '%' as CopyEditor

fork query

edited aug 14 12 Brad Mace

created may 28 11 marat.snowbear