各位大佬，帮忙看看这个题吧，我快崩溃了

图三，是参考结果，用sql语句写出来运行结果和这个一致

又是这个平仓题，我记得之前发过几次的。

begin
DECLARE
@MATNR varchar(50)
,@YEAR_MONTH int
,@received int
,@returned int
,@fkje int
,@ID int
CREATE TABLE #temp(
[ID] [INT] NULL,
[MAT] [nvarchar](50) NULL,
[YEARMONTH] [int] NULL,
[RECEIVED] [int] NULL,
[RETURNED] [int] NULL,
[FKJE] [int] NULL
)
DECLARE CURSOR1 CURSOR FOR
SELECT YEAR_MONTH , MATNR , RECEIVED,RETURNED
FROM [dbo].[TRAIN_MATERIAL_PURCHASE]
order by MATNR ,YEAR_MONTH
set @ID=1
set @FKJE=0
open CURSOR1
FETCH next from CURSOR1 into @YEAR_MONTH,@MATNR,@RECEIVED,@RETURNED
WHILE @@FETCH_STATUS =0
begin
if (@FKJE>=0 )
begin
set @FKJE =@RECEIVED-@RETURNED
end
else if (@FKJE<0 )
begin
set @FKJE =@RECEIVED -@RETURNED+@FKJE
end
insert into #temp( [ID] , [MAT] , [YEARMONTH] , [RECEIVED] , [RETURNED] , [FKJE] )
values(@ID,@MATNR,@YEAR_MONTH,@RECEIVED,@RETURNED,@FKJE)
set @ID=@ID+1
FETCH next from CURSOR1 into @YEAR_MONTH,@MATNR,@RECEIVED,@RETURNED
end
CLOSE CURSOR1
DEALLOCATE CURSOR1
select * from #temp
end

SELECT MATNR ,YEAR_MONTH , RECEIVED,RETURNED ,RECEIVED-RETURNED FKJE
into #temp1
FROM [dbo].[TRAIN_MATERIAL_PURCHASE] a
select MATNR ,YEAR_MONTH , RECEIVED,RETURNED
,case
when (select count(1) from [TRAIN_MATERIAL_PURCHASE] where MATNR=a.MATNR and YEAR_MONTH<a.YEAR_MONTH)=0 then RECEIVED-RETURNED
when (select top 1 FKJE from #temp1 where MATNR=a.MATNR and YEAR_MONTH<a.YEAR_MONTH order by YEAR_MONTH desc) >=0 then RECEIVED-RETURNED
else RECEIVED-RETURNED+(select top 1 FKJE from #temp1 where MATNR=a.MATNR and YEAR_MONTH<a.YEAR_MONTH order by YEAR_MONTH desc) end FKJE
into #temp2
from #temp1 a
select MATNR ,YEAR_MONTH , RECEIVED,RETURNED
,case
when (select count(1) from [TRAIN_MATERIAL_PURCHASE] where MATNR=a.MATNR and YEAR_MONTH<a.YEAR_MONTH)=0 then RECEIVED-RETURNED
when (select top 1 FKJE from #temp2 where MATNR=a.MATNR and YEAR_MONTH<a.YEAR_MONTH order by YEAR_MONTH desc) >=0 then RECEIVED-RETURNED
else RECEIVED-RETURNED+(select top 1 FKJE from #temp2 where MATNR=a.MATNR and YEAR_MONTH<a.YEAR_MONTH order by YEAR_MONTH desc) end FKJE
into #temp3
from #temp2 a
select row_number() over( order by MATNR ,YEAR_MONTH) ID, * from #temp3