DECLARE TypeWorkID, TypeWorkTimeID int DEFAULT 0;

  DECLARE HourDay float DEFAULT 0.00;

  DECLARE TabNum, ArrDay varchar(10) DEFAULT NULL;

 
CREATE TEMPORARY TABLE tbldrv_tmp (
    id int(11) NOT NULL AUTO_INCREMENT,
    uniq_field int(50) UNIQUE NOT NULL,    
    type_work_id varchar(11) DEFAULT NULL,
    type_work_time_id varchar(11) DEFAULT NULL,
    flag_simv tinyint(1) DEFAULT FALSE, 
    tab_num int(11) DEFAULT NULL,   
    day_1 varchar(10) DEFAULT NULL, day_2 varchar(10) DEFAULT NULL, day_3 varchar(10) DEFAULT NULL, day_4 varchar(10) DEFAULT NULL,
    day_5 varchar(10) DEFAULT NULL, day_6 varchar(10) DEFAULT NULL, day_7 varchar(10) DEFAULT NULL, day_8 varchar(10) DEFAULT NULL,
    day_9 varchar(10) DEFAULT NULL, day_10 varchar(10) DEFAULT NULL, day_11 varchar(10) DEFAULT NULL, day_12 varchar(10) DEFAULT NULL,
    day_13 varchar(10) DEFAULT NULL, day_14 varchar(10) DEFAULT NULL, day_15 varchar(10) DEFAULT NULL, day_16 varchar(10) DEFAULT NULL,
    day_17 varchar(10) DEFAULT NULL, day_18 varchar(10) DEFAULT NULL, day_19 varchar(10) DEFAULT NULL, day_20 varchar(10) DEFAULT NULL,
    day_21 varchar(10) DEFAULT NULL, day_22 varchar(10) DEFAULT NULL, day_23 varchar(10) DEFAULT NULL, day_24 varchar(10) DEFAULT NULL,
    day_25 varchar(10) DEFAULT NULL, day_26 varchar(10) DEFAULT NULL, day_27 varchar(10) DEFAULT NULL, day_28 varchar(10) DEFAULT NULL,
    day_29 varchar(10) DEFAULT NULL, day_30 varchar(10) DEFAULT NULL, day_31 varchar(10) DEFAULT NULL,
    PRIMARY KEY (id)
  )
  ENGINE = MYISAM;

                  SET ArrDay:=23;
                  SET TabNum:=526;
                  SET TypeWorkTimeID:=1;
                  SET TypeWorkID:=1;              
                  SET HourDay:=8;
                  SET @tmp_ins_str:=CONCAT('INSERT INTO tbldrv_tmp (uniq_field, type_work_id, type_work_time_id, flag_simv, tab_num, '
                                          , CONCAT('day_', ArrDay),') VALUES (', CAST(CONCAT(TabNum, TypeWorkTimeID, '0') AS UNSIGNED), ', ', TypeWorkID, ', ', TypeWorkTimeID, ', '
                                          , 'False', ', ', TabNum, ', ', HourDay
                                          , ') ON DUPLICATE KEY UPDATE ', CONCAT('day_', ArrDay), ' = ', CONCAT('day_', ArrDay), ' + ', HourDay);   
                  
                  PREPARE tmp_ins FROM @tmp_ins_str;
                  EXECUTE tmp_ins;
                  DEALLOCATE PREPARE tmp_ins;