GRANT EXECUTE ON dbo.calcorder_ask TO PUBLIC
GO
GRANT REFERENCES ON dbo.calcorder_ask TO PUBLIC
GO

USE [forex_test]
GO
/****** Object:  StoredProcedure [dbo].[calcorder_ask]    Script Date: 15.07.2019 12:09:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE dbo.calcorder_ask
(
	@order_date_1	datetime	= null,
	@order_date_2	datetime	= null,
)
AS
BEGIN
/***************************************************************************************************************

Процедура:		dbo.calcorder_ask(...)

Описание:		Отчет: Очередь квитовки

Параметры:		@order_date_1	datetime		дата ОТ
			@order_date_2	datetime		дата ДО

Создал:			11.07.2019	Пупкин., создал

***************************************************************************************************************/
	select 
			cf.order_id,
			cf.order_date,
			cf.order_priority,
			cf.order_status
	FROM
			calcorder cf (nolock)
	WHERE
		        (    cf.order_date	>=	@order_date_1	or @order_date_1	IS NULL )	/* Дата с		*/
		       and ( cf.order_date	<=	@order_date_2	or @order_date_2	IS NULL )	/* Дата по		*/
	ORDER BY 
			cf.order_id
END
GO

GRANT EXECUTE ON dbo.calcorder_ask TO PUBLIC
GO

GRANT REFERENCES ON dbo.calcorder_ask TO PUBLIC
GO