Is it possible to place columns after a pivoted column? For instance, I have a Test with the Questions for the test pivoted to form a single row, and would like the score and proficiency level to be shown after the questions, like so:
Student Test Name Q1 Q2 Q3 Q4 Q5 Score Proficiency Level
Student 1 Test 1 A C B D C 85.3
Distinguished
Student 2 Test 2 B C B D D 92.3
Proficient
My query simply wants to put the pivoted columns at the end of the row...
Select *
from (
Select distinct
null StudentNo,
t.TestName AssessmentTitle,
q.QuestionNumber,
q.RawAnswer,
null Score,
null PerfLevel,
From Test t
Join Question q on q.TestID = t.TestID
and t.TestID = 410832) as src
Pivot (max(RawAnswer)
For QuestionNumber in ([1],[2],[3],[4],[5])) as pvt)
