YARATISH YOKI O'ZGARTIRISH PROSEDURASI dif.get_request_to_cancel_not_confirmed_delivery AS BEGIN SET NOCOUNT ON; e'lon qil @delivery_id bigint , @request_queue_id bigint , @request_id bigint , @contents varchar(max) tanlang top 1 @delivery_id = od.delivery_id , @request_queue_id = null , @request_id = odr.request_id , @contents = cn.contents opsapi.request rq dan ops.contents cn bilan cn.contents_uid = rq.contents_uid dif.ops_delivery_request odr bilan odr.request_id = rq.request_id dif.ops_delivery od bilan od.delivery_id = odr.delivery_id qachon 1 = 1 va rq.state_code = 200 va rq.scheme_name = 'исх:опс.лк.отмена.слота.ффд' va od.state_code = 257 tartib bilan rq.request_id yangilash opsapi.request holat_kodi = 202 , holat_nomi = opsapi.get_state_name(202) , holat_izohi = null , holat_sanasi = getdate() , yangilangan_at = getdate() qachon request_id = @request_id tanlang @request_queue_id request_queue_id, @request_id request_id, @contents contents END GO