NewCallCenter5.1_API/sql/sql_20180111...

/****** Object:  StoredProcedure [dbo].[P_GetHolidays]    Script Date: 01/11/2018 16:08:22 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[P_GetHolidays]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[P_GetHolidays]
GO


/****** Object:  StoredProcedure [dbo].[P_GetHolidays]    Script Date: 01/11/2018 16:08:22 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[P_GetHolidays] 
AS
BEGIN

	SET NOCOUNT ON;
	
	declare @count int=0;
	
	
	SELECT @count=count(*) FROM T_Sys_WorkCalendar 
		WHERE getdate() between F_DateId and DATEADD(dd,1,F_DateId) 
			AND F_WorkingFlag=1 
			AND Convert(varchar(20),getdate(),108)>=Convert(varchar(20),'07:30:00',108) 
			AND Convert(varchar(20),getdate(),108)<=Convert(varchar(20),'18:30:00',108)
	
	
	
	select @count as HolidayVerify
END



GO