Сложность с триггером

CREATE PROCEDURE newz
(
    @costyear DATE
)
AS
BEGIN 
 
INSERT INTO pereocenka (pereocenka.costyear)
VALUES (@costyear)
 
END
RETURN
-------------------------------------------
EXECUTE newz @costyear = "10.10.2016"
 
-------------------------------------------
DROP PROCEDURE newz
 
-------------------------------------------
 
CREATE TRIGGER per ON pereocenka
FOR INSERT
AS
IF @@RowCount=0
RETURN
IF @@RowCount>1
BEGIN
RAISERROR('Ошибка!',16,1)
ROLLBACK TRAN
RETURN
END
 
DECLARE @DATE AS DATE
    SELECT  @DATE=GETDATE()
 
    DECLARE @cost_after AS DEC(8,2)
    SELECT @cost_after FROM inserted--pereocenka
 
    DECLARE @date_start AS DATE
    SELECT  @date_start FROM inserted--imushestvo
 
    DECLARE @cost_initial AS DEC(8,2)
    SELECT  @cost_initial=cost_initial FROM imushestvo
 
    DECLARE @life_time AS INT
    SELECT  @life_time=life_time FROM imushestvo
 
    DECLARE @dif AS INT
    SELECT  @dif=DATEDIFF(YEAR,@DATE,@date_start)
 
    DECLARE @r AS INT
    SELECT @r=(@life_time*100)/@dif
 
    IF (@r BETWEEN 0 AND 15)
        BEGIN
        SELECT @cost_after = @cost_initial*1
        UPDATE pereocenka
        SET cost_after=@cost_after
        RETURN
        END
    IF (@r BETWEEN 15 AND 35)
        BEGIN
        SELECT @cost_after = @cost_initial*0.8
        END
    IF (@r BETWEEN 35 AND 50)
        BEGIN
        SELECT @cost_after = @cost_initial*0.6
        END
    IF (@r BETWEEN 50 AND 75)
        BEGIN
        SELECT @cost_after = @cost_initial*0.3
        END
    IF (@r BETWEEN 75 AND 99)
        BEGIN
        SELECT @cost_after = @cost_initial*0.1
        END
    /*IF (@r <= 100)
        BEGIN
        END
    UPDATE pereocenka
    SET cost_after=@cost_after*/