You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.
With xMatters, you'll never miss a beat.
SELECT q.QuestionNumber, q.Abstract, a.AnswerNumber, a.AnswerText, resp.FinalScore, grp.GroupName FROM A_AssessmentInfo AS qs INNER JOIN A_Question AS q ON q.AssessmentID = qs.ID INNER JOIN A_Answer AS a ON a.QuestionID = q.ID LEFT OUTER JOIN A_Response AS resp ON a.ID = resp.AnswerID LEFT OUTER JOIN A_ProjectUsers AS pu ON pu.PersonID = resp.PersonID AND pu.UserResponseStatusID = 2 AND pu.AssessmentID = @QuestionSetID LEFT OUTER JOIN [$Groups] AS grp ON grp.ID = resp.GroupID AND resp.GroupID IS NOT NULL WHERE (q.AssessmentID = @QuestionSetID) ORDER BY q.QuestionNumber, a.AnswerNumber
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.