[ mladenmp @ 08.12.2015. 17:33 ] @
Može li mi neko reći gdje je greška u mojoj proceduri? Code: create procedure yearly_income_tax_calculation_federal() begin declare salary float; declare tax float; SELECT salary_annually INTO salary FROM ndcga776_payroll_db.payroll WHERE payroll_id=2; IF (salary>0 AND salary<=44701) THEN SET tax = salary*0.15; ELSE IF (salary>44701 and salary<=89401) THEN SET tax=44701*0.15+(salary-44701)*0.22; ELSE IF (salary>89401 and salary<=138586) THEN SET tax=44701*0.15+(89401-44701)*0.22+(salary-89401)*0.26; END IF END IF ELSE SET tax=44701*0.15+(89401-44701)*0.22+(138596-89401)*0.26+(salary-138586)*0.29; END IF END Ova procedura mi ne radi u MySQL Workbench 6.2 64bit (Local Instance MySQL 5.6) |