[Homework] Functions Triggers And Transactions - Problem 13 Calculating Interest
Гърми ми при вход на даннит Balance, @input, @period . Някой може ли да помогне
CREATE PROCEDURE usp_CalculateFutureValueForAccount(@input float)
AS
BEGIN
declare @period int = 5;
SELECT ah.Id AS [Account Id], ah.FirstName, ah.LastName, a.Balance AS [Current Balance] FROM AccountHolders AS ah
JOIN Accounts AS a ON
ah.Id = a.AccountHolderId
WHERE [Bank].dbo.ufn_CalculateFutureValue (Balance, @input, @period)
END