1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| CREATE PROCEDURE [GetCapital]
(
@age numeric,
@capital_calcule numeric
)
AS
DECLARE @Capital_verse numeric
if @capital_calcule is not null
begin
SELECT @Capital_verse=min([Capital versé])
FROM [Protection F as PF, Protection P as PP]
WHERE (PF.age = @age and [PF.Capital versé] >= @capital_calcule) or (PP.age = @age and [PP.Capital versé] >= @capital_calcule);
end
else
begin
SELECT [cotisation annuelle] as Cotisation, [Capital versé] as Capital
FROM [Protection F as PF, Protection P as PP]
WHERE PP.age = @age or PF.age = @age;
end
GOE] |
Partager