Recent Unanswered Questions Sorted By Views

0

Please login or register to vote for this query.

(click on this box to dismiss)

Database Administrators

Q&A for database professionals who wish to improve their database skills and learn from others in the community

SELECT TOP 100 q.Id AS [Post Link], q.Tags, q.ViewCount, 
    q.Score, q.AnswerCount, 
    /* Find the highest-scoring answer: */
    TopAnswerScore = (SELECT TOP 1 a.Score FROM dbo.Posts a WHERE q.Id = a.ParentId ORDER BY a.Score DESC),
    BodyLength = CASE 
        WHEN LEN(Body) < 500 THEN 'Tiny' 
        WHEN LEN(Body) < 2000 THEN 'Normal' 
        ELSE 'Looooong' END,
    q.OwnerUserId AS [User Link]
  FROM dbo.Posts q
  WHERE q.PostTypeId = 1
    AND q.AcceptedAnswerId IS NULL 
    AND q.DeletionDate IS NULL
    AND q.ClosedDate IS NULL
    AND q.CreationDate >= DATEADD(dd, (-1 * ##DaysBack:int?30##), GETDATE())
    AND q.OwnerUserId NOT IN
      (SELECT TRY_CAST(value AS BIGINT) FROM STRING_SPLIT(##IgnoredUserIds:string?-1,26837,2639##, ','))
  ORDER BY q.ViewCount DESC;
  
-- IgnoredUserIds: Ignored UserIds "Comma-delimited list of IDs to ignore"
-- DaysBack: Days back to search "Integer. The further back you go, the longer this might take."

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results