2

Please login or register to vote for this query.

(click on this box to dismiss)

Returns the number of closed questions that weren't closed as duplicates, as a proportion of all questions. Units are "questions per thousand".

Q&A for SharePoint enthusiasts

-- Non-duplicated closed questions
-- Returns a count of the number of closed questions that weren't closed as duplicates.

select
cast(1000 * (
SELECT  
  cast(COUNT(*) as float)
FROM PostHistory q
WHERE
  q.PostHistoryTypeId = 10
AND
  q.Comment != 1
)/(
select
  cast(COUNT(*) as float)
FROM Posts
) + .5 as int)

fork query

created sep 29 11 Andrew Stacey