两日期间的工作日分钟数(只排除了周六周日)

ALTER FUNCTION [dbo].[F_worktotalminues](@dt_begin DATETIME,
                         @dt_end   DATETIME
)
RETURNS INT
AS
  BEGIN
      DECLARE @holidDay INT
      set @holidDay = 0
      DECLARE @totalminues INT
      set @totalminues = 0
      declare @inidt_begin datetime
      set @inidt_begin = @dt_begin   
      WHILE @dt_begin <= @dt_end
      BEGIN
set @totalminues = case when (@@datefirst + datepart(weekday,@dt_begin)-1)%7 between 1 and 5 then @totalminues + 1 else @totalminues end
set @dt_begin = dateadd(mi,1,@dt_begin)
      END
      RETURN case @totalminues when 0 then 0 else @totalminues - 1 end
  END