Q&A for Salesforce administrators, implementation experts, developers and anybody in-between
-- Get Suggested Edit summary information for questions and answers in identified question set. -- Create post id of identified question set. CREATE TABLE #PostJavaSpecificTag (Id int) insert #PostJavaSpecificTag select distinct P.id FROM Posts P INNER JOIN PostTags T ON P.id = T.PostId WHERE P.posttypeid = 1 and T.tagid = 11549 and P.id > ##StartPostId## and P.id < ##EndPostId## INTERSECT select distinct P.id FROM Posts P INNER JOIN PostTags T ON P.id = T.PostId WHERE P.posttypeid = 1 and T.tagid = 17 and P.id > ##StartPostId## and P.id < ##EndPostId## -- Get post vote information from question -- Create post id of identified question set. CREATE TABLE #SE2 (Id int, V2 int) insert #SE2 select SE.PostId, count(*) as VoteTypeIdCount FROM SuggestedEdits SE, SuggestedEditVotes SV WHERE PostId in ( select P.Id FROM Posts P INNER JOIN #PostJavaSpecificTag J ON P.Id = J.Id UNION select A.Id FROM Posts P INNER JOIN #PostJavaSpecificTag J ON P.Id = J.Id INNER JOIN Posts A ON P.Id = A.ParentId ) AND SE.Id = SV.SuggestedEditId AND SV.VoteTypeId = 2 group by SE.PostId, VoteTypeId order by Postid CREATE TABLE #SE3 (Id int, V3 int) insert #SE3 select SE.PostId, count(*) as VoteTypeIdCount FROM SuggestedEdits SE, SuggestedEditVotes SV WHERE PostId in ( select P.Id FROM Posts P INNER JOIN #PostJavaSpecificTag J ON P.Id = J.Id UNION select A.Id FROM Posts P INNER JOIN #PostJavaSpecificTag J ON P.Id = J.Id INNER JOIN Posts A ON P.Id = A.ParentId ) AND SE.Id = SV.SuggestedEditId AND SV.VoteTypeId = 3 group by SE.PostId, VoteTypeId order by Postid --select #SE2.Id, V2, V3, V2+V3, V2-V3 --FROM #SE2 -- OUTER JOIN #SE3 ON #SE2.Id = #SE3.Id --order by #SE2.Id select isnull(S2.Id, S3.Id) Id, Isnull(V2,0), IsNull(V3,0), V2-V3 Diff, V2+V3 Tot from #SE2 S2 FULL OUTER JOIN #SE3 S3 ON S2.Id = S3.Id