When i run the following query on its own and give the @Tutor parameter value All it seems to work.
SELECT VIEW_TUTOR.TUTOR_ID, VIEW_TUTOR.NAME, COURSES.DELIVERYTYPE, COURSES.SYLLABUS, QUESTION_RESULTS.RESPONSE, COURSES.DATE,
(CASE WHEN dbo.QUESTION_RESULTS.RESPONSE =...