我有下面的代码块，计算为一个长期的上课，但我需要它来应付4terms。

Declare 

 @total int = 0,

 @counter int = 0,

 @strt date,

 @end date

Begin 

  set @total= (select distinct DATEDIFF(DAY,startdate,enddate) 

			from SchoolTerms

			 where EmisCode ='500226884' 

		   AND CurrentYear='2009'

		   AND Quater='Term1'	)

  set @strt=(Select Distinct StartDate

		   From SchoolTerms

		   where EmisCode ='500226884' 

		   AND CurrentYear='2009'

		   AND Quater='Term1')

  Set @end=(Select Distinct EndDate

		   From SchoolTerms

		   where EmisCode ='500226884' 

		   AND CurrentYear='2009'

		   AND Quater='Term1')

  while (@strt<@end) 

  BEGIN

	if DATEPART(weekday,@strt)=7  or DATEPART(weekday,@strt)= 1 

	begin

	    Declare @totals int = 0

 

	end

	else

	Begin

	

		set @counter+=1

		

		--print @counter

		--print DATEPART(weekday,@strt)

    end

    set @strt=dateadd(day,1,@strt)

    --

  End

  print @strt

  print @end

  print @counter

--print @total

End;

当我注释掉的语句"和之四="字词1"我得到以下错误。