p_uzd_id Decimal 9,2 Begin Set @summa := (select Sum(līgumi.summa) from ligumi, uznemumi where uznemumi.uznemuma_id = ligumi.uznemums and uzņēmumi.uznemuma_id = p_uzd_id); Set @attalums := (select pirkumi.attalums from ligumi, uznemumi, pirkumi where uznemumi.uznemuma_id = ligumi.uznemums and ligumi.liguma_id = pirkumi.liguma_id and and uzņēmumi.uznamuma_id = p_uzd_id); Set @transCena := @attalums * 1.22; Set @kopejaSumma := @summa + @transCena; Set @kopajaSumma := @kopejaSumma * 1.71; Return @kopejaSumma; END
©