sql 2000
i have this sql stored procedure i want the last coloumn fAcc_Total to be updated when a record is inserted.
the value in the fBill_Amount should be add to the value of the fAcc_Total in the same time the record is inserted if there is a value in the previous row of the fAcc_Total the fBill_Amount should be added to that value and update the new row
if any one know can you show me how please
****************************************************************************************
create procedure InsertPayment(@bn NChar(10),@un NChar(60),@ba float,@ccn NChar(20),@cct NChar(10),@at float)
as
insert into
Payment_Info(cBill_No,cUser_Name,fBill_Amount,cCC_Number,cCC_Type,fAcc_Total)
values(@bn,@un ,@ba ,@ccn ,@cct,@at)