CREATE PROCEDURE pro_ArrayLec @Sdate varchar(10), @Edate varchar(10) ,@SetDATA VARCHAR(8) ,@Deptmajorcode varchar(4) ,@RegSemester varchar(2) ,@RegYear varchar(4) as declare @week int set @week=-1 if @SetDATA='' begin set @SetDATA='30001801' end WHILE (@week) < 15 begin set @week =@week +1 set @Sdate =DateAdd(ww,@week,''+@Edate+'') -- 강의등록일 업데이트 update 수업운영관리 set..