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