select top 100 concat('


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('', 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

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