自定义起始及截止日期,计算周期 函数

USE [BM]
GO
/****** Object:  UserDefinedFunction [dbo].[ZfunWeek]    Script Date: 2015-12-19 15:30:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER function  [dbo].[ZfunWeek](@SDate CHAR(8),@EDate CHAR(8),@week int) returns
int
--计算周期
as 
begin

 declare  @weektemp int;-- declare @SDate char(8),@EDate char(8), @week int

 SELECT @weektemp=0 --, @SDate='20151201',@EDate='20151220',@week=0
while (@EDate>=@SDate)
begin
set @SDate=CONVERT(char(8),dateadd(dd,7,@SDate),112);
set  @week=@week+1
set @weektemp= @week
end
return @weektemp
--select @weektemp
end