I have a table EXAMINATION_QUESTIONS and a table EXAMINATION_SCHEDULER.
I wish to populate table SCHEDULER with records from a table EXAMINATION_QUESTIONS Using a conditional query.
Table EXAMINATION_QUESTIONS needs to be populated with 2 extra column which are not present in table which is giving me the problem.
I have enclosed a query which i build and i am sure that there is some syntax in the query i am using.
CREATE PROCEDURE [dbo].[ExamMode_SetupExamQuestionforTestTaker]
SET NOCOUNT ON;
INSERT INTO EXAMINATION_SCHEDULER