Find All Reviews Pertaining to a Particular Post

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 100 
  PostID AS [Post Link], 
  'site://review/' +
        CASE WHEN rtt.Id = 1 OR rtt.Id = 4 OR rtt.Id = 5
            THEN REPLACE(LOWER(rtt.Name), ' ', '-') + 's'
        WHEN rtt.Id = 2
            THEN 'close'
        WHEN rtt.Id = 3
            THEN REPLACE(LOWER(rtt.Name), ' ', '-')
        WHEN rtt.Id = 6
            THEN 'reopen'
        END
        + '/' + CAST(rt.Id AS nvarchar) AS [Review Link],
    rtt.Name AS [Review Type]

FROM
    ReviewTasks rt
    INNER JOIN ReviewTaskTypes rtt ON rt.ReviewTaskTypeId = rtt.Id
WHERE PostID = ##PostID:int##

Enter Parameters

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