create procedure dbo.%PROC%
  @date_b_d varchar(30) = null,
  @date_e_d varchar(30) = null,
  @broker_id_s varchar(30) = null,
  @deal_type int=null
as
declare
        @action_id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric
begin

set nocount on

select @action_id = %ACTION_ID%

.CHECK_USER
.CHECK_VIEW

if @date_b_d is null
  .EXIT_MESSAGE('Не задана дата начала')

if @date_e_d is null
  .EXIT_MESSAGE('Не задана дата окнчания')

if @broker_id_s is null
  .EXIT_MESSAGE('Не задана организация учета')


select
  @broker_id_s as broker_id_s,
  @date_b_d as date_b_d,
  @date_e_d as date_e_d,
  @deal_type as deal_type

end