ALTER trigger [dbo].[timetableautomatedins] on [dbo].[college_timetableautomated] after insert AS
   DECLARE @SWV_NEW_CO VARCHAR(255)
   DECLARE @SWV_NEW_COLLEGECD VARCHAR(255)
   DECLARE @SWV_NEW_COURSECD VARCHAR(255)
   DECLARE @SWV_NEW_CLASSCD VARCHAR(255)
   DECLARE @SWV_NEW_DIVISION VARCHAR(255)
   DECLARE @SWV_NEW_YEARCD VARCHAR(255)
   DECLARE @SWV_NEW_STARTDATE VARCHAR(255)
   DECLARE @SWV_NEW_ENDDATE VARCHAR(255)
   DECLARE @SWV_NEW_DAY VARCHAR(255)
   DECLARE @SWV_NEW_BUILDINGCD VARCHAR(255)
   DECLARE @SWV_NEW_FLOORNO VARCHAR(255)
   DECLARE @SWV_NEW_ROOMNO VARCHAR(255)
   DECLARE @SWV_NEW_WING VARCHAR(255)
   DECLARE @SWV_NEW_FROMTIME VARCHAR(255)
   DECLARE @SWV_NEW_TOTIME VARCHAR(255)
   DECLARE @SWV_NEW_SUBJECTID VARCHAR(255)
   DECLARE @SWV_NEW_TEACHERCD VARCHAR(255)
   DECLARE @SWV_Cursor_For_NEW CURSOR
   SET @SWV_Cursor_For_NEW = CURSOR  FOR SELECT co, collegecd, coursecd, classcd, division, yearcd, startdate, enddate, day, buildingcd, floorno, roomno, wing, fromtime, totime, subjectid, teachercd FROM inserted
   OPEN @SWV_Cursor_For_NEW
   FETCH NEXT FROM @SWV_Cursor_For_NEW INTO @SWV_NEW_CO,@SWV_NEW_COLLEGECD,@SWV_NEW_COURSECD,@SWV_NEW_CLASSCD,@SWV_NEW_DIVISION,
   @SWV_NEW_YEARCD,@SWV_NEW_STARTDATE,@SWV_NEW_ENDDATE,@SWV_NEW_DAY,
   @SWV_NEW_BUILDINGCD,@SWV_NEW_FLOORNO,@SWV_NEW_ROOMNO,@SWV_NEW_WING,
   @SWV_NEW_FROMTIME,@SWV_NEW_TOTIME,@SWV_NEW_SUBJECTID,@SWV_NEW_TEACHERCD
   WHILE @@FETCH_STATUS = 0
   begin
      DECLARE @vholidaydate DATETIME
      DECLARE @vstartdate DATETIME
      DECLARE @venddate DATETIME
      DECLARE @vtimetablestartfrom DATETIME
      DECLARE @vtimetableendfrom DATETIME
      DECLARE @vtimetableday VARCHAR(50)
      DECLARE @c1 CURSOR
      DECLARE @c2 CURSOR
      SET @c1 = CURSOR  FOR select startdate,enddate from college_classmaster where co = @SWV_NEW_CO and
      collegecd = @SWV_NEW_COLLEGECD and coursecd = @SWV_NEW_COURSECD and classcd = @SWV_NEW_CLASSCD
      and division = @SWV_NEW_DIVISION
      open @c1
      fetch @c1 into @vstartdate,@venddate
      SET @vtimetablestartfrom = @SWV_NEW_STARTDATE
      SET @vtimetableendfrom = @SWV_NEW_ENDDATE
      SET @vtimetableday = @SWV_NEW_DAY
      while 1 = 1
      begin
         SET @vtimetablestartfrom = CONVERT(DATETIME,@vtimetablestartfrom)+1
         while 1 = 1
         begin
            SET @c2 = CURSOR  FOR select docdate from college_holidays where co = @SWV_NEW_CO and collegecd = @SWV_NEW_COLLEGECD
            and yearcd = @SWV_NEW_YEARCD and docdate = @vtimetablestartfrom
            open @c2
            fetch @c2 into @vholidaydate
            if @@FETCH_STATUS = 0
               SET @vtimetablestartfrom = CONVERT(DATETIME,@vtimetablestartfrom)+1
         else
            BREAK

            close @c2
         end
         if SUBSTRING(CONVERT(VARCHAR(30),CONVERT(DATETIME,@vtimetablestartfrom),110),1,3) = SUBSTRING(@SWV_NEW_DAY,1,3) and @vtimetablestartfrom between @vstartdate and @venddate
            insert into college_timetable(co,collegecd,coursecd,classcd,division,buildingcd,floorno,
roomno,wing,dateofclass,fromtime,totime,yearcd,subjectid,teachercd)
values(@SWV_NEW_CO,@SWV_NEW_COLLEGECD,@SWV_NEW_COURSECD,@SWV_NEW_CLASSCD,@SWV_NEW_DIVISION,@SWV_NEW_BUILDINGCD,@SWV_NEW_FLOORNO,
@SWV_NEW_ROOMNO,@SWV_NEW_WING,@vtimetablestartfrom,@SWV_NEW_FROMTIME,@SWV_NEW_TOTIME,@SWV_NEW_YEARCD,@SWV_NEW_SUBJECTID,@SWV_NEW_TEACHERCD)

         if @vtimetablestartfrom > @vtimetableendfrom
            BREAK
      end
      close @c1
      FETCH NEXT FROM @SWV_Cursor_For_NEW INTO @SWV_NEW_CO,@SWV_NEW_COLLEGECD,@SWV_NEW_COURSECD,@SWV_NEW_CLASSCD,@SWV_NEW_DIVISION,
      @SWV_NEW_YEARCD,@SWV_NEW_STARTDATE,@SWV_NEW_ENDDATE,@SWV_NEW_DAY,
      @SWV_NEW_BUILDINGCD,@SWV_NEW_FLOORNO,@SWV_NEW_ROOMNO,@SWV_NEW_WING,
      @SWV_NEW_FROMTIME,@SWV_NEW_TOTIME,@SWV_NEW_SUBJECTID,@SWV_NEW_TEACHERCD
   end
   CLOSE @SWV_Cursor_For_NEW