ЗапросSQLВыб5="
					|If Exists
					|(
					|SELECT     discount_size.discount, cards_discount.discount_size                      
					|FROM         discount_size Cross JOIN
					|                     cards_discount
					|where ( ? < ? ) 
					|)
					|return
					|ELSE 
					| IF EXISTS 
					|(
					|SELECT     cards_discount.discount_size, cards_discount.date_start, cards_discount.date_end, cards_discount.code_1c82                      
					|FROM cards_discount
					|where cards_discount.date_end is Null 
					|)
					|begin
					|update cards_discount SET date_end =CONVERT(DATETIME, '"+Формат(Дата(ДатаДока-1),"ДФ=yyyy-MM-dd")+"',102)
					|insert into cards_discount(date_start,code_1c82,discount_size,date_end) values(CONVERT(DATETIME, '"+Формат(Дата(ДатаДока),"ДФ=yyyy-MM-dd")+"',102), ? ,? , Null)
					|END";	
										

	ЗапросВыб5.CommandText = ЗапросSQLВыб5; 
	ЗапросВыб4.Parameters.Refresh();
	ЗапросВыб4.Parameters.Item(0).Value = дисконт;
	ЗапросВыб4.Parameters.Item(1).Value = дисконт_сизе;
	ЗапросВыб4.Parameters.Item(2).Value = коде_дисконт_1с82;
	ЗапросВыб4.Parameters.Item(3).Value = дисконт;

	Рез5=ЗапросВыб5.Execute();