CREATE FUNCTION fnc_NumberOfWeekEnds(@dFrom DATETIME, @dTo DATETIME)
RETURNS INT AS
BEGIN
Declare @weekends int
Set @weekends = 0
While @dFrom <= @dTo Begin
If ((datepart(dw, @dFrom) = 1) OR (datepart(dw, @dFrom) = 7))
Set @weekends
= @weekends + 1
Set @dFrom
= DateAdd(d, 1, @dFrom)
End
Return (@weekends)
END
No comments:
Post a Comment