ALTER PROCEDURE VIEW_RESULTS @formID INT AS DECLARE @questionID INT DECLARE @applicantID INT DECLARE @applicantName varchar(MAX) DECLARE @qID INT DECLARE @NewLineChar AS CHAR(2) = CHAR(13) + CHAR(10) DECLARE all_applicants_cursor CURSOR FOR SELECT applicantID FROM FormFillers WHERE formID=@formID DECLARE questions_cursor CURSOR FOR SELECT questionID FROM FormQuestions WHERE formID=@formID open all_applicants_cursor FETCH NEXT FROM all_applicants_cursor INTO @applicantID WHILE @@FETCH_STATUS = 0 BEGIN SELECT applicantName + CHAR(13)+CHAR(10) From RegisteredApplicants WHERE applicantID=@applicantID open questions_cursor FETCH NEXT FROM questions_cursor INTO @qID WHILE @@FETCH_STATUS = 0 BEGIN SELECT Q.questionText FROM FormQuestions Q, Answers A WHERE Q.questionID=@qID AND A.questionID=@qID AND A.applicantID=@applicantID FETCH NEXT FROM questions_cursor INTO @qID END CLOSE questions_cursor; DEALLOCATE questions_cursor; FETCH NEXT FROM all_applicants_cursor INTO @applicantID END CLOSE all_applicants_cursor; DEALLOCATE all_applicants_cursor;
SELECT Q.questionText FROM FormQuestions Q, Answers A WHERE Q.questionID=@qID AND A.questionID=@qID AND A.applicantID=@applicantID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)