Database

smcnulty2000 wrote:

Short answer: try removing the index.

public static void writeInFile(String filePath,string contents)

-- You can try this out by invoking the statement: select dbo.GetBusinessDays(cast ('10/01/2007' as datetime),cast('10/09/2007' as datetime))

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date, ,>
-- Description:	<Description, ,>
-- =============================================
ALTER function [dbo].[GetBusinessDays]
(
     @StartDate datetime,
     @EndDate datetime
) 
returns int
 as
begin

  declare @DaysBetween int
  declare @BusinessDays int
  declare @Cnt int
  declare @EvalDate datetime

  select @DaysBetween = 0
  select @BusinessDays = 0
  select @Cnt=0

  select @DaysBetween = datediff(Day,@StartDate,@endDate) + 1  
   
   while @Cnt < @DaysBetween
     begin
  
            select @EvalDate = @StartDate + @Cnt
        
            --if (dbo.IsDateAHoliday(@EvalDate)  = 0)
            --BEGIN
                if ((datepart(dw,@EvalDate) <> 1) and (datepart(dw,@EvalDate) <> 7))
                    BEGIN
                         select @BusinessDays = @BusinessDays + 1
                    END
            --END
      
          select @Cnt = @Cnt + 1
    end

 return @BusinessDays
end