Bu sql sorgusu birden fazla depo ile çalışan işletmeler de depo miktarlarının toplamının ve tüm depo toplamlarının tek satırda gösterilmesini sağlar.


SELECT KODU,ADI,KODU+' '+ADI AS STOK,


ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND GDEPO='02'),0) -
ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND CDEPO='02'),0) [02 Antalya Depo],


ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND GDEPO='03'),0) -
ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND CDEPO='03'),0) [03 Alanya Depo],


ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND GDEPO='04'),0) -
ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND CDEPO='04'),0) [04 İstanbul Depo],


ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND GDEPO='05'),0) -
ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND CDEPO='05'),0) [05 İzmir Depo],


ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND GDEPO='06'),0) -
ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND CDEPO='06'),0) [06 Antep Depo],


ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND GDEPO='10'),0) -
ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND CDEPO='10'),0) [10 Merkez Depo],


ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND GDEPO<>''),0) -
ISNULL((SELECT SUM(MIKTAR) FROM STOKHAR S WHERE STOK.KODU=S.KODU AND CDEPO<>''),0) [Toplam]
FROM STOK