1

Please login or register to vote for this query.

(click on this box to dismiss)

Closed non duplicate questions, plus total questions and percentage (for the lazy)

Q&A for expert programmers interested in professional discussions on software development

SET NOCOUNT OFF;

DECLARE @Total INT;
  SELECT @Total = COUNT(*) FROM Posts p WHERE p.PostTypeId = 1;

DECLARE @ClosedNonDupes INT
  SELECT @ClosedNonDupes = COUNT(*) FROM PostHistory q WHERE q.PostHistoryTypeId = 10 AND q.Comment != 1;

DECLARE @ClosedAll INT
  SELECT @ClosedAll = COUNT(*) FROM PostHistory q WHERE q.PostHistoryTypeId = 10;

SET NOCOUNT ON;

SELECT @ClosedNonDupes AS [Closed Non Duplicate], @ClosedAll AS [Closed Total], @Total AS [Total Questions], 100 * (@ClosedNonDupes * 1.0 / @Total * 1.0) AS [Percentage NonDupes], 100 * (@ClosedAll * 1.0 / @Total * 1.0) AS [Percentage All];

fork query

edited feb 1 12

created jan 24 12 jon.doe6850