CREATE PROCEDURE "GUZHANOV"."MOVE_MONEY" (
    IN TABLE_NAME1	VARCHAR( 20 ),
    IN DATE_START	DATE,
    IN DATE_END	DATE )
  SPECIFIC "GUZHANOV"."MOVE_MONEY"
  LANGUAGE SQL
  NOT DETERMINISTIC
  EXTERNAL ACTION
  MODIFIES SQL DATA
  CALLED ON NULL INPUT
  INHERIT SPECIAL REGISTERS
BEGIN
declare saldo1 decimal( 22 , 2 );
declare saldo2 decimal( 22 , 2 );
DECLARE dynSQL varchar( 600 );

  FOR GetName as select distinct name from operation.operation
    where ID in ( select ID_OPERATION from OPERATION.ACCOUNT )
    or ID in ( select ID_OPERATION from OPERATION.INPAYMENT )
    or ID in ( select ID_OPERATION from OPERATION.TRANSACTION ) group by name
  DO
  
    SET SALDO1 = (select sum(ot.value) as v from operation.transaction ot 
    where ot.value_date between date(DATE_START) and date(date_end)  
    and ot.id_account_debet is null and ot.id_operation in 
    (select id from operation.operation where name = getname.name));
  
    SET SALDO2 = (select sum(ot.value) as v from operation.transaction ot 
    where ot.value_date between date(DATE_START) and date(date_end)  
    and ot.id_account_debet is not null and ot.id_operation in 
    (select id from operation.operation where name = getname.name));
  
    SET dynSQL = 'insert into '||TABLE_NAME1||' (name, summ) values ('|| getname.name ||', '||decfloat(saldo1-saldo2)||')';
    EXECUTE IMMEDIATE dynSQL;
  
  END FOR;
END