InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 22:56:12 GMT20http://www.sqlservercentral.com/Forums/Topic1417450-2875-1.aspxYour answer told me that I was having problems with the browser (Chrome). Tried it with Firefox - works well.Mon, 11 Feb 2013 11:41:33 GMTDave Vromanhttp://www.sqlservercentral.com/Forums/Topic1417450-2875-1.aspx[quote][b]Dave Vroman (2/8/2013)[/b][hr]Couldn't get yours to work. Too many errors in the post. We're using this one. I wanted to see the difference. The table of holidays contains only holidays that fall on business days.[code]CREATE FUNCTION [dbo].[CalculateBusinessDays]( @StartDate DATE, @EndDate DATE)RETURNS INTEGERASBEGIN IF @EndDate IS NULL SELECT @EndDate = GETDATE() RETURN CONVERT(INTEGER, (DATEDIFF(dd, @StartDate, @EndDate) + 1) - (DATEDIFF(wk, @StartDate, @EndDate) * 2) - (CASE WHEN DATENAME(dw, @StartDate) = 'Sunday' THEN 1 ELSE 0 END) - (CASE WHEN DATENAME(dw, @EndDate) = 'Saturday' THEN 1 ELSE 0 END) - ISNULL((SELECT COUNT(*) FROM tblHoliDays WHERE @StartDate &lt;= Holiday AND @EndDate &gt;= Holiday), 0))END[/code][/quote]What sorts of errors are you getting when you try to run the function?Sat, 09 Feb 2013 08:48:38 GMTzulmanclockhttp://www.sqlservercentral.com/Forums/Topic1417450-2875-1.aspxCouldn't get yours to work. Too many errors in the post. We're using this one. I wanted to see the difference. The table of holidays contains only holidays that fall on business days.[code]CREATE FUNCTION [dbo].[CalculateBusinessDays]( @StartDate DATE, @EndDate DATE)RETURNS INTEGERASBEGIN IF @EndDate IS NULL SELECT @EndDate = GETDATE() RETURN CONVERT(INTEGER, (DATEDIFF(dd, @StartDate, @EndDate) + 1) - (DATEDIFF(wk, @StartDate, @EndDate) * 2) - (CASE WHEN DATENAME(dw, @StartDate) = 'Sunday' THEN 1 ELSE 0 END) - (CASE WHEN DATENAME(dw, @EndDate) = 'Saturday' THEN 1 ELSE 0 END) - ISNULL((SELECT COUNT(*) FROM tblHoliDays WHERE @StartDate &lt;= Holiday AND @EndDate &gt;= Holiday), 0))END[/code]Fri, 08 Feb 2013 17:38:38 GMTDave Vromanhttp://www.sqlservercentral.com/Forums/Topic1417450-2875-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Workdays/95876/">Number of Working Days</A>[/B]Thu, 07 Feb 2013 21:07:37 GMTzulmanclock