Passing Values To Trigger

Hi all,

I have a store procedure which updates one row of a table. I need to use a trigger, so that it will also update another row in the same table. Like Debit and Credit. Somehow I am not able to pass variables from SP to trigger. Below are my SP and Trigger codes.

STORE PROCEDURE ALTER PROCEDURE dbo.Transfer



(@online varchar(50),

@amount smallmoney,@toaccount varchar(10)

)

 

AS

Begindeclare @total smallmoney declare @total1 smallmoney

set @total1=1

select @total=TotalAmount from Customers where OnlineID=@online

if @total>=@amount

set @total=dbo.Calulator(@total,@amount)

else

set @total1=0

End

update Customers set TotalAmount=@total where OnlineID=@online

RETURN @total1

TRIGGER ALTER TRIGGER dbo.Updcust ON Customers

FOR update

 

AS

BEGINdeclare @total2 smallmoney

declare @total3 smallmoneydeclare @amount smallmoney

declare @toaccount varchar(10)

select @total2=TotalAmount from Customers where AccountNumber=8776450012

set @total3=@total2+@amount

UPDATE Customers set TotalAmount=@total3 where AccountNumber=8776450012

END

please help