create procedure dbo.%PROC%
as
begin
declare @operday datetime
select @operday = .OPERDAY
declare @broker_id numeric
declare @broker_code varchar(255)
declare @broker_name varchar(255)
select @broker_id = .ORG_FROM_PARTNER((.ORGANIZATION))

select
  @broker_name = tb_broker_change.broker_name,
  @broker_code = tb_broker_change.broker_code
  from tb_broker_change
 where tb_broker_change.id = @broker_id

select
  convert(datetime,@operday) as date_b_d,
  dateadd(day,1,@operday) as date_e_d,
  convert(varchar(30), @broker_id) as owner_id_s,
  @broker_name as broker_name,
  @broker_code as broker_code,
  convert(varchar(30), null) as dogovor_id_s,
  convert(varchar(255), null) as dogovor_name,
  0 as deal_type

end