gustav<3databases@clowncollege

CREATE a PROCEDURE that copies a CourseBudget (including ALL CourseBudgetElements) AND saves it AS a NEW ROW IN CourseBudget (AND NEW ROWS IN CourseBudgetElements). CREATE PROCEDURE arguments AS needed. (Tip: INSERT...SELECT TO copy many existing ROWS).

CREATE PROCEDURE USELESSCOPY
(@p_courseBudget_idCourse INT,
@p_courseBudget_idDeparment INT,
@p_budgetYearCourseBudget INT,
@p_studyPeriodCourseBudget INT,
@p_locationCourseBudget CHAR(3),
@p_languageCourseBudget CHAR(2),
@p_numstudentCourseBudget INT,

@p_courseBudgetElements_idCourseBudget INT,
@p_courseBudgetElements_nameCourseElement CHAR(2),
@p_courseBudgetElements_akronymPersonnel CHAR (3),
@p_hoursCoursebudgetElements INT)
AS
BEGIN
INSERT INTO CourseBudget
SELECT (CourseBudget_idCourse, CourseBudget_idDeparment, budgetYearCourseBudget, studyPeriodCourseBudget, locationCourseBudget, languageCourseBudget, numstudentCourseBudget)
FROM CourseBudget
VALUES (@p_courseBudget_idCourse,@p_courseBudget_idDeparment,@p_budgetYearCourseBudget,@p_studyPeriodCourseBudget,@p_locationCourseBudget,@p_languageCourseBudget,@p_numstudentCourseBudget)
END;