get business days

gistfile1.sql

ALTER function [dbo].[udf_GetBusinessDays]
(
       @startDate datetime
       ,@enddate datetime
)
RETURNS int
BEGIN
       Declare @ret int
       Set @ret = datediff(d,@startDate,@enddate)
			   - datediff(wk,@startDate,@enddate) * 2
			   - CASE
				  WHEN DATENAME(dw, @startdate) <> 'Saturday' AND DATENAME(dw, @enddate) = 'Saturday' THEN 1
				  WHEN DATENAME(dw, @startdate) = 'Saturday' AND DATENAME(dw, @enddate) <> 'Saturday' THEN -1
				  ELSE 0
				  END
       return @ret
END