CREATE FUNCTION [OPR].[f_GetLastWorkDay] 
(
	-- Add the parameters for the function here
	@DateStart datetime,	--Стартовая дата
	@CountWorkDay int		--Количество рабочих дней
)
RETURNS datetime
AS
BEGIN
	-- Declare the return variable here
	DECLARE @DateEnd datetime
	DECLARE @n int = 0
	DECLARE @next bit
	DECLARE @ex0 int
	DECLARE @ex1 int
	
	set @DateEnd = @DateStart

	--Циклом добавляем дни
	while (@n<@CountWorkDay)
	BEGIN
		set @n=@n+1
		set @next = 0
		set @DateEnd = DATEADD(day,1,@DateEnd)
		while (@next = 0)
		BEGIN
			IF(DATEPART(weekday, @DateEnd) = 7
			or DATEPART(weekday, @DateEnd) = 1)
			begin
				set @ex0 = (select COUNT(*) from dbo.j_Holidays j_H where  j_H.Date_Holiday in(@DateEnd) AND j_H.Status_Holiday = 0)
				if (@ex0=1)
				begin
					break
				end
				else
				begin
					set @DateEnd = DATEADD(day,1,@DateEnd)
					continue
				end
			end
			ELSE
			begin
				set @ex1 = (select COUNT(*) from dbo.j_Holidays j_H where j_H.Date_Holiday in(@DateEnd) AND j_H.Status_Holiday = 1)
				if (@ex1=1)
				begin
					set @DateEnd = DATEADD(day,1,@DateEnd)
					continue
				end
				else
				begin
					break
				end
			end		
		END
	END
	-- Return the result of the function
	RETURN @DateEnd
END
GO

IF(DATEPART(weekday, @DateEnd) = 7 or DATEPART(weekday, @DateEnd) = 1)

SET DATEFIRST