select top 100 concat('http://stackoverflow.com/review-ta...

0

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 concat('http://stackoverflow.com/review-task/', t.Id, '|', rrr.Name COLLATE DATABASE_DEFAULT)
from ReviewTaskResults r
join ReviewTasks t on t.CompletedByReviewTaskId=r.Id
join ReviewRejectionReasons rrr on rrr.Id=r.RejectionReasonId
order by t.CreationDate desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results