Code: Select all
declare @satislar integer=0
declare @alislar integer=0
declare @sayimlar integer=0
SELECT @satislar-=isnull(sum([miktar]),0)
FROM [bardata].[dbo].[fis_detay]
left join dbo.fis on islemno=fis.id
where urunid=161 and fis.tur =0
SELECT @alislar=isnull(sum([miktar]),0)
FROM [bardata].[dbo].[fis_detay]
left join dbo.fis on islemno=fis.id
where urunid=161 and fis.tur =1
SELECT @sayimlar+=isnull(sum([miktar]),0)
FROM [bardata].[dbo].[fis_detay]
left join dbo.fis on islemno=fis.id
where urunid=161 and fis.tur =40
select 'Alışlar'=@alislar,'Satışlar'=@satislar,'Sayım'=@sayimlar,'Net stok'= (@alislar+@satislar)+@sayimlar