Files

17 lines
278 B
SQL

DROP procedure IF EXISTS `SetCashAdvanceBudget`
#
CREATE PROCEDURE `SetCashAdvanceBudget`(
IN cashAdvanceId INTEGER,
IN budgetId INTEGER
)
BEGIN
UPDATE CashAdvances SET CashAdvances.FinancialAccountId=budgetId
WHERE CashAdvances.CashAdvanceId=cashAdvanceId;
END