I have below query(output of it attached in quiz1.jpg)
Select Qid as Queid,QText as Question,
OptionA,OptionB,OptionC,OptionD,QAns as Answer
from examQB eq inner join Exam e
on eq.examid = e.examid
where e.ExamId = @ExamId and eq.isDeleted = 0 and e.isdeleted = 0
order by newid()
I need to change this query to display output as quizquery.bmp
The optionA/B/C/D column should come in rows under one column.
Your help is really appreciated.