یکی از روشها استفاده از کرسر میتونه باشه.
Declare @pay bigint,
@back bigint,
@mod bigint
Set @mod = 0
CREATE TABLE #Temp(
[pay] [bigint] NULL CONSTRAINT [DF_pay] DEFAULT ((0)),
[back] [bigint] NULL CONSTRAINT [DF_back] DEFAULT ((0)),
[mod] [bigint] NULL CONSTRAINT [DF_mod] DEFAULT ((0))
) ON [PRIMARY]
Declare curs Cursor For Select Pay, Back From TableName
Open curs
While ( 1=1 )
begin
Fetch Next From curs Into @pay, @back
If @@Fetch_Status <> 0 Break
Set @Mod = @mod + @Pay - @Back
Insert into #temp(Pay, Back, Mod) values (@Pay, @Back, @Mod)
end
Select * From #Temp
Deallocate curs
drop table #Temp