endnu et cursor issue jeg ikke forstår
Jeg har denne sp, den skulle gerne kunne beregne rente beløbet via min egen function, men den fejler når jeg kalder den medMsg 512, Level 16, State 1, Procedure tilskriv_rente, Line 24
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Msg 512, Level 16, State 1, Procedure tilskriv_rente, Line 24
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Msg 512, Level 16, State 1, Procedure tilskriv_rente, Line 24
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Msg 512, Level 16, State 1, Procedure tilskriv_rente, Line 24
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
koden her, skulle gerne loope gennem de selctede rows og berenge renten og skrive den ud via print.
ALTER PROCEDURE [dbo].[tilskriv_rente]
AS
BEGIN
declare @renteBelob float
declare @kontonr smallint
declare pegefinger CURSOR for
select kontonr from renteOpgorelse
open pegefinger
FETCH NEXT FROM pegefinger into @kontonr
WHILE @@FETCH_STATUS = 0 BEGIN
set @renteBelob = (select dbo.Beregn_rente(renteSaldo,dage,renteSats)
from renteOpgorelse
where kontonr = @kontonr)
/* her vil jeg indsætte rente belobet på konto's */
print cast(@renteBelob as varchar(20))
FETCH NEXT FROM pegefinger into @kontonr
END --WHILE
close pegefinger
deallocate pegefinger
END
GO