📄 Tam SQL Kodu (Referans)

Analiz eklerken buradan kod parçalarını kopyalayabilirsiniz

CREATE VIEW dbo.[00001_SATIS_IADELER]
AS
SELECT        QQ.STOCKREF, SUM(QQ.I2022) AS AIDE2022, SUM(QQ.I2021) AS IADE2021, SUM(QQ.I2020) AS IADE2020, SUM(QQ.I2022) + SUM(QQ.I2021) AS SONIKI, SUM(QQ.I2022) + SUM(QQ.I2021) + SUM(QQ.I2020) AS TOPLAM
FROM            ((SELECT        STOCKREF, SUM(AMOUNT) AS I2022, 0 AS I2021, 0 AS I2020
                            FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                            WHERE        CANCELLED = 0 AND TRCODE = 3 AND LINETYPE = 0
                            GROUP BY STOCKREF)
                         UNION ALL
                         (SELECT        STOCKREF, 0 AS I2022, SUM(AMOUNT) AS I2021, 0 AS I2020
                          FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                          WHERE        CANCELLED = 0 AND TRCODE = 3 AND LINETYPE = 0
                          GROUP BY STOCKREF)
UNION ALL
(SELECT        STOCKREF, 0 AS I2022, 0 AS I2021, SUM(AMOUNT) AS I2020
 FROM            [UNIVERSALDB].[dbo].LG_011_06_STLINE
 WHERE        CANCELLED = 0 AND TRCODE = 3 AND LINETYPE = 0
 GROUP BY STOCKREF)
UNION ALL
(SELECT        STOCKREF, 0 AS I2022, 0 AS I2021, SUM(AMOUNT) AS I2020
 FROM            [UNIVERSALDB].[dbo].LG_011_05_STLINE
 WHERE        CANCELLED = 0 AND TRCODE = 3 AND LINETYPE = 0
 GROUP BY STOCKREF)) QQ
GROUP BY QQ.STOCKREF

➕ Yeni Kod Analizi Ekle

📋 Mevcut Analizler (6)

Adım 1 
SELECT STOCKREF, SUM(AMOUNT) AS I2022, 0 AS I2021, 0 AS I2020
FROM [UNIVERSALDB].[dbo].LG_011_08_STLINE
WHERE CANCELLED = 0 AND TRCODE = 3 AND LINET...

Ne yapıyor? LG_011_08_STLINE içinden iade satırlarını seçiyor (TRCODE=3). Satırları STOCKREF ...

Adım 2 
SELECT STOCKREF, 0 AS I2022, SUM(AMOUNT) AS I2021, 0 AS I2020
FROM [UNIVERSALDB].[dbo].LG_011_07_STLINE
WHERE CANCELLED = 0 AND TRCODE = 3 AND LINET...

Ne yapıyor? Aynı filtrelerle (iptal değil, toptan satış iade, malzeme satırı) bu sefer LG_011_0 ...

Adım 3 
SELECT STOCKREF, 0 AS I2022, 0 AS I2021, SUM(AMOUNT) AS I2020
FROM [UNIVERSALDB].[dbo].LG_011_06_STLINE
WHERE CANCELLED = 0 AND TRCODE = 3 AND LINET...

Ne yapıyor? LG_011_06_STLINE döneminden toptan satış iade miktarlarını stok bazında topluyor. ...

Adım 4 
SELECT STOCKREF, 0 AS I2022, 0 AS I2021, SUM(AMOUNT) AS I2020
FROM [UNIVERSALDB].[dbo].LG_011_05_STLINE
WHERE CANCELLED = 0 AND TRCODE = 3 AND LINET...

Ne yapıyor? LG_011_05_STLINE döneminden toptan satış iade toplamını alıyor, ama bunu da I202 ...

Adım 5 
... (08 select)
UNION ALL (07 select)
UNION ALL (06 select)
UNION ALL (05 select)

Mantık: Her select aynı kolonları üretir (I2022, I2021, I2020) ama sadece biri dolu, diğerleri ...

Adım 6 
SELECT QQ.STOCKREF,
       SUM(QQ.I2022) AS AIDE2022,
       SUM(QQ.I2021) AS IADE2021,
       SUM(QQ.I2020) AS IADE2020,
       SUM(QQ.I2022) + S...

Burada yapılanlar: QQ içindeki satırlar tekrar STOCKREF bazında gruplanır. Aynı stok için: ...