0

Please login or register to vote for this query.

(click on this box to dismiss)

This searches questions that are still open but inactive... Prompted for Minimum Score and Answer Count.

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- Inactive open Questions
-- This searches questions that are still open but inactive... Prompted for Minimum Score and Answer Count.

Declare @minScore int = ##MinScore##
declare @ansCount int = ##AnswerCount##

SELECT  
  p.Id AS [Post Link],
  p.LastActivityDate,
  p.Score
  FROM dbo.Posts p

 WHERE p.Score > @minScore AND p.CreationDate <= DATEADD(mm, -2, GETDATE()) AND p.AcceptedAnswerId IS NULL AND p.AnswerCount <= @ansCount 
  AND p.ClosedDate IS NULL
  ORDER BY p.LastActivityDate

fork query

created jan 28 11 ivoflipse