CREATE TABLE `dirty_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_record` datetime NOT NULL,
  `date1_record` date NOT NULL,
  `lic_sch` varchar(16) DEFAULT NULL,
  `fam` varchar(64) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `otch` varchar(64) DEFAULT NULL,
  `kod_st` varchar(8) DEFAULT NULL,
  `kod_tn` varchar(8) DEFAULT NULL,
  `yearmon` date DEFAULT NULL,
  `data_new` int(11) DEFAULT NULL,
  `data_kon` int(11) DEFAULT NULL,
  `date_kon` date DEFAULT NULL,
  `base` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE DEFINER=`Oleg`@`` PROCEDURE `zap_copy`()
BEGIN
INSERT INTO dirty_data
	select 
kartab_askue.lic_sch from kartab_askue
where del=0 ;
END

BEGIN
INSERT INTO dirty_data (date_record,lic_sch,data_kon,date_kon,base,fam,`name`,otch,cod_tn,cod_st,data_new,yearmon)
select 
now() As time1,
kartab_askue.lic_sch,
kartab_askue.data_kon,
kartab_askue.date_kon,
kartab_askue.base,
kartab_askue.fam,
kartab_askue.`name`,
kartab_askue.otch,
kartab_askue.cod_tn,
kartab_askue.cod_st,
t1.data_new,
t1.yearmon
from 
kartab_askue Left JOIN 
(select MAX(kartkvgd_askue.yearmon) As yearmon,
MAX(kartkvgd_askue.data_new) As data_new, 
kartkvgd_askue.lic_sch As lic_sch
from 
kartkvgd_askue
where kartkvgd_askue.del=0
GROUP BY kartkvgd_askue.lic_sch) As t1 
on kartab_askue.lic_sch=t1.lic_sch
where kartab_askue.del=0
END

CREATE TABLE `dirty_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_record` date NOT NULL,
  `mon_year` varchar(7) NOT NULL,
  `lic_sch` varchar(16) DEFAULT NULL,
  `fam` varchar(64) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `otch` varchar(64) DEFAULT NULL,
  `kod_st` varchar(8) DEFAULT NULL,
  `kod_tn` varchar(8) DEFAULT NULL,
  `yearmon` date DEFAULT NULL,
  `data_new` int(11) DEFAULT NULL,
  `data_kon` int(11) DEFAULT NULL,
  `date_kon` date DEFAULT NULL,
  `base` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=196607 DEFAULT CHARSET=utf8;

CREATE DEFINER=`Oleg`@`` PROCEDURE `zap`()
BEGIN
INSERT INTO dirty_data(mon_year,date_record,lic_sch,data_kon,date_kon,base,fam,`name`,otch,kod_tn,kod_st,data_new,yearmon)
	select 
DATE_FORMAT(CURRENT_DATE(),'%c-%Y') As mon_year,
now() As date_record,
kartab_askue.lic_sch,
kartab_askue.data_kon,
kartab_askue.date_kon,
kartab_askue.base,
kartab_askue.fam,
kartab_askue.`name`,
kartab_askue.otch,
kartab_askue.cod_tn,
kartab_askue.cod_st,
t1.data_new,
t1.yearmon
from 
kartab_askue Left JOIN 
(select MAX(kartkvgd_askue.yearmon) As yearmon,
MAX(kartkvgd_askue.data_new) As data_new, 
kartkvgd_askue.lic_sch As lic_sch
from 
kartkvgd_askue
where kartkvgd_askue.del=0
GROUP BY kartkvgd_askue.lic_sch) As t1 
on kartab_askue.lic_sch=t1.lic_sch
where kartab_askue.del=0;

END

select
kartab_askue.lic_sch,
kartab_askue.data_kon,
kartab_askue.date_kon,
kartab_askue.base,
(select yearmon from kartkvgd_askue where lic_sch=kartab_askue.lic_sch order by yearmon desc limit 1) as yearmon,
(select data_new from kartkvgd_askue where lic_sch=kartab_askue.lic_sch order by yearmon desc limit 1) as data_new
from 
kartab_askue 
where kartab_askue.del=0

SELECT
kartab_askue.lic_sch,
kartab_askue.fam,
kartab_askue.`name`,
kartab_askue.otch,
kartab_askue.data_kon,
(SELECT data_new from kartkvgd_askue where lic_sch=kartab_askue.lic_sch and del=0 order by yearmon desc,data_new asc limit 1) As data_new,
kartab_askue.date_kon,
(SELECT yearmon from kartkvgd_askue where lic_sch=kartab_askue.lic_sch and del=0 order by yearmon desc,data_new asc limit 1) As yearmon,
kartab_askue.cod_st,
kartab_askue.cod_tn,
kartab_askue.base
from 
kartab_askue 
where kartab_askue.del=0

CREATE DEFINER=`Oleg`@`` PROCEDURE `del`(IN `year_mon` char)
BEGIN
DELETE  FROM dirty_data WHERE dirty_data.year_mon_record=year_mon;

END

Для Индекс = 0 По Мас.Количество() - 1 Цикл
	
objComm.CommandText = "UPDATE dirty_data SET dirty_data.pred_dostov="+Строка(Мас[Индекс].ДостоверныПред)+",dirty_data.sled_dostov="+Строка(Мас[Индекс].ДостоверныСлед)+",dirty_data.nalich_lic_sch="+Мас[Индекс].ЛицевойСчетСуществует+",dirty_data.pred_pokaz="+Окр(Мас[Индекс].ПоказанияПред)+",dirty_data.sled_pokaz="+Окр(Мас[Индекс].ПоказанияСлед)+",dirty_data.date_update=now() 
|WHERE dirty_data.lic_sch="+Строка(Мас[Индекс].ЛицевойСчет)+" and dirty_data.year_mon_record="+Строка(Мас[Индекс].Дата)+";";
objComm.Execute();

 КонецЦикла;

UPDATE dirty_data SET dirty_data.pred_dostov=Да,dirty_data.sled_dostov=Да,dirty_data.nalich_lic_sch=Да,dirty_data.pred_pokaz=11 549,dirty_data.sled_pokaz=11 767,dirty_data.date_update=now() 
WHERE dirty_data.lic_sch=11007701921 and dirty_data.year_mon_record=2016-4;

objComm.CommandText = "UPDATE dirty_data SET dirty_data.pred_dostov="+Число(Мас[Индекс].ДостоверныПред)+",dirty_data.sled_dostov="+Число(Мас[Индекс].ДостоверныСлед)+",dirty_data.nalich_lic_sch="+Число(Мас[Индекс].ЛицевойСчетСуществует)+",dirty_data.pred_pokaz="+Число(Окр(Мас[Индекс].ПоказанияПред))+",dirty_data.sled_pokaz="+Число(Окр(Мас[Индекс].ПоказанияСлед))+",dirty_data.date_update=now() 
|WHERE dirty_data.lic_sch="+Мас[Индекс].ЛицевойСчет+" and dirty_data.year_mon_record="+Мас[Индекс].Дата+";";