declare @total int
set @total=(select max(id) from cashflow_1month_interests)

declare @row int
 set @row=1

DECLARE @pTDOPNDAT            varchar(10)
declare @TBTEMPRATE           float
DECLARE @TDOPNAMT          decimal(20,0)
DECLARE @pdate                 nvarchar(10)
DECLARE @interest             decimal(20,0)
DECLARE @sql                  varchar(4000)
DECLARE @TFDPDURATN                  int 
DECLARE @i                  int 


while @row<=@total
begin
 
 set @TDOPNAMT =(select cast (TDOPNAMT as decimal(20,0) ) from cashflow_1month_interests where id=@row)
 set @TBTEMPRATE =(select cast (TBTEMPRATE as float )from cashflow_1month_interests where id=@row)
 set @TFDPDURATN=(select cast(TFDPDURATN as int) from cashflow_1month_interests where id=@row) 
 set @pdate=(select PTDOPNDAT from cashflow_1month_interests where id=@row)

set @i =1
 while @i<= @TFDPDURATN
 begin
 
 set @interest = @TDOPNAMT*(@TBTEMPRATE)*
 dbo.ShamsiDateDiff (@pdate,dbo.nextMonth(@pdate))/36500
 
 if @i< cast(@TFDPDURATN as int)
 begin
   set @sql='UPDATE cashflow_1month_interests  SET intersts_of_month'+cast(@i as varchar(2))+' ='+cast( @interest as nvarchar(255))+' where id='+cast (@row as nvarchar(255))
   print( @sql  )     
   exec (@sql)   
 end
 if  @i= cast(@TFDPDURATN as int)
 begin
  set   @sql='UPDATE cashflow_1month_interests  SET intersts_of_month'+cast(@i as varchar(2))+' = '+cast( @interest+@TDOPNAMT as nvarchar(255))+' where id='+cast (@row as nvarchar(255))
  print( @sql  )
  exec (@sql)
 end 
 
 set @pdate=dbo.nextMonth(@pdate)
 set @i=@i+1
 end
set @row=@row+1
end