create procedure dbo.%PROC% @sid varchar(30) = null
as
.BEGIN('N')
/*
.CHECK_USER
.CHECK_UPDATE
*/
begin tran

select @id = convert(numeric, @sid)

declare
@in_date datetime,
@numb varchar(50),
@str varchar(255)


update td_depo_docs
set in_date = (select reg_date
                 from ts_reg_report
                      where id=@id)
  where id=@id

select @in_date = (select reg_date
                 from ts_reg_report
                      where id=@id)

select @numb = (select in_no
                 from td_depo_docs
                      where id=@id)

/*
.BACK_GEN_NO(@numb,1,@in_date)

update td_depo_docs
set in_no = @numb
where id = @id
*/

select @str = 'Отчет регистратора о принятых заявках'+' №: '+@numb+' от '+.DATE_TO_STR(@in_date)

update t_items
set item_name = @str
where id = @id




/*-------Проводки ----------*/
commit tran
.END