Number of Working Days

Create FUNCTION [dbo].[WorkDays]
(
	-- Add the parameters for the function here
	 
)
RETURNS int
AS
BEGIN
	-- Declare the return variable here
	DECLARE @WorkDays int

	-- Add the T-SQL statements to compute the return value here
	SELECT @WorkDays = (SELECT COUNT(number+1)
												 FROM   master..spt_values 
														WHERE  type='p'
															AND    number <datepart(dd, DateAdd(day,-1,DateAdd(Month,1,DateAdd(Month,
																						  DateDiff(Month, 0, GETDATE()),0))))
															AND    datename(WEEKDAY,DateAdd(Month, DateDiff(Month, 0, GetDate()),
																						 number) ) not in ('Saturday','Sunday')
															AND number+1 NOT IN(SELECT DATEPART(DAY,HOLIDAY) FROM HOLIDAYS
													WHERE DATEPART(MONTH,HOLIDAY ) = DATEPART(MONTH,GETDATE())
													AND DATEPART(YEAR,HOLIDAY) = DATEPART(YEAR,GETDATE())))

	-- Return the result of the function
	RETURN @WorkDays

END