I am working on a student database for a project and I want the range of modules assigned to a particular cohort to be automatically inserted into the relevant tables once the cohort has been allocated to each student. I am trying to create a procedure which will insert this specific data to the relevant table once the administrator identifies the correct cohort for the student. The data in question i.e.the modules are pre-determined. The data is inserted to the relevant table using the Primary Key= student ID.It From researching the task it looks like a stored procedure is the way to go. Any suggestions as to how the syntax should be created would be much appreciated.
Bookmarks