1-) MSSQL RMOS - while cursor ile sanal tablo dönmek her donen veri ile birşey yapmak

IF object_id('tempdb..#tablo') is not null

BEGIN

   DROP TABLE #tablo

END

GO

select distinct Rsat_Fisno into #tablo from Cst_Recete_Satis where Rsat_Tarih> '2021-09-18'

--select * from #tablo

Declare @Rsat_Fisno2 Nvarchar(MAX)

Declare Dongu Cursor For Select Rsat_Fisno From #tablo

Open Dongu

Fetch Next From Dongu Into @Rsat_Fisno2

WHILE @@FETCH_STATUS = 0

BEGIN

   --print ('Fişno '+@Rsat_Fisno2)

declare @toplam nvarchar(50) = (select sum(Rsat_Fiyat) as rsatfiyat   from Cst_Recete_Satis where Rsat_Fisno=@Rsat_Fisno2 and Rsat_Ba='B')

declare @toplam2 nvarchar(50) =(select sum(Rsat_Fiyat) as rsatfiyat   from Cst_Recete_Satis where Rsat_Fisno=@Rsat_Fisno2 and Rsat_Ba='A')

if(@toplam <> @toplam2)

begin

print('eşit değildir '+@toplam+' -- '+@toplam2)

end

Fetch Next From Dongu Into @Rsat_Fisno2

END

Close Dongu

DEALLOCATE Dongu