Monday, May 19, 2014

Get number of weekends between two dates using sql server

This function will return the total number of weekends in two dates



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