--REZERWY--

CREATE FUNCTION [dbo].[Rezerwa_tVx] (@rok FLOAT, @plec FLOAT, @wiek FLOAT, @t int, @stopa FLOAT)

RETURNS FLOAT

BEGIN

RETURN dbo.Ax(@rok, @plec, @wiek+@t, @stopa)-dbo.Px(@rok, @plec, @wiek, @stopa)*dbo.RENTA_B_G(@rok, @plec, @wiek+@t, @stopa)

END

SELECT dbo.Rezerwa_tVx(2010,1,20,10,0.05)

SELECT distinct X as t into wiek from TTZ

SELECT dbo.Rezerwa_tVx(2001,1,20,t,0.05), dbo.Rezerwa_tVx(2010,1,20,t,0.05) from wiek

where t<80

SELECT dbo.Rezerwa_tVx(2001,1,20,t,0.05), dbo.Rezerwa_tVx(2010,1,20,t,0.05) from wiek

where t<80

order by t

insert into TTZ values (1,101,0,2001)

DELETE TTZ

WHERE PLEC=1 AND X=101 AND rok=2010