SON_SATIS_MIKTARLARI

Genel Bilgiler

Uygulama SQL Server

Nesne Türü View

Dönem Hassasiyeti ⚠️ Devirde Güncellenmeli

Oluşturulma 23.12.2025 15:52

Son Güncelleme 23.12.2025 17:28

Notlar

Düzenle

Henüz not eklenmemiş.

+ Not ekle

İstatistikler

Kod Analizi

Satır

Kullandığı

Kullanan

🔗

İlişki Bulunamadı

Bu nesne için henüz ilişki tanımlanmamış. İlişki Analizi sayfasından otomatik analiz başlatabilirsiniz.

Tam SQL Kodu

Düzenle

CREATE VIEW dbo.SON_SATIS_MIKTARLARI
AS
SELECT        STOCKREF, SUM(UC) AS UC, SUM(ALTI) AS ALTI, SUM(DOKUZ) AS DOKUZ
FROM            ((SELECT        QQ.STOCKREF, SUM(QQ.AMOUNT) AS UC, 0 AS ALTI, 0 AS DOKUZ
                            FROM            ((SELECT        STOCKREF, AMOUNT, DATE_
                                                        FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                                                        WHERE        TRCODE = 8 AND CANCELLED = 0)
                                                     UNION ALL
                                                     (SELECT        STOCKREF, AMOUNT, DATE_
                                                      FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                                                      WHERE        TRCODE = 8 AND CANCELLED = 0)) QQ
WHERE        QQ.DATE_ > CAST(DATEADD(DAY, - 90, GETDATE()) AS DATE)
GROUP BY QQ.STOCKREF
HAVING        SUM(QQ.AMOUNT) > 0)
UNION ALL
(SELECT        QQ.STOCKREF, 0 AS UC, SUM(QQ.AMOUNT) AS ALTI, 0 AS DOKUZ
 FROM            ((SELECT        STOCKREF, AMOUNT, DATE_
                             FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                             WHERE        TRCODE = 8 AND CANCELLED = 0)
                          UNION ALL
                          (SELECT        STOCKREF, AMOUNT, DATE_
                           FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                           WHERE        TRCODE = 8 AND CANCELLED = 0)) QQ
WHERE        QQ.DATE_ > CAST(DATEADD(DAY, - 180, GETDATE()) AS DATE)
GROUP BY QQ.STOCKREF
HAVING        SUM(QQ.AMOUNT) > 0)
UNION ALL
(SELECT        QQ.STOCKREF, 0 AS UC, 0 AS ALTI, SUM(QQ.AMOUNT) AS DOKUZ
 FROM            ((SELECT        STOCKREF, AMOUNT, DATE_
                             FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                             WHERE        TRCODE = 8 AND CANCELLED = 0)
                          UNION ALL
                          (SELECT        STOCKREF, AMOUNT, DATE_
                           FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                           WHERE        TRCODE = 8 AND CANCELLED = 0)) QQ
WHERE        QQ.DATE_ > CAST(DATEADD(DAY, - 270, GETDATE()) AS DATE)
GROUP BY QQ.STOCKREF
HAVING        SUM(QQ.AMOUNT) > 0)) KK
GROUP BY KK.STOCKREF

Devir Edilmiş Kod

011_08 → 011_09 (1 değişiklik)

ALTER VIEW dbo.SON_SATIS_MIKTARLARI
AS
SELECT        STOCKREF, SUM(UC) AS UC, SUM(ALTI) AS ALTI, SUM(DOKUZ) AS DOKUZ
FROM            ((SELECT        QQ.STOCKREF, SUM(QQ.AMOUNT) AS UC, 0 AS ALTI, 0 AS DOKUZ
                            FROM            ((SELECT        STOCKREF, AMOUNT, DATE_
                                                        FROM            [UNIVERSALDB].[dbo].LG_011_09_STLINE
                                                        WHERE        TRCODE = 8 AND CANCELLED = 0)
                         UNION ALL
                         (SELECT        QQ.STOCKREF, SUM(QQ.AMOUNT) AS UC, 0 AS ALTI, 0 AS DOKUZ
                            FROM            ((SELECT        STOCKREF, AMOUNT, DATE_
                                                        FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                                                        WHERE        TRCODE = 8 AND CANCELLED = 0)
                                                     UNION ALL
                                                     (SELECT        STOCKREF, AMOUNT, DATE_
                                                      FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                                                      WHERE        TRCODE = 8 AND CANCELLED = 0)) QQ
WHERE        QQ.DATE_ > CAST(DATEADD(DAY, - 90, GETDATE()) AS DATE)
GROUP BY QQ.STOCKREF
HAVING        SUM(QQ.AMOUNT) > 0)
UNION ALL
(SELECT        QQ.STOCKREF, 0 AS UC, SUM(QQ.AMOUNT) AS ALTI, 0 AS DOKUZ
 FROM            ((SELECT        STOCKREF, AMOUNT, DATE_
                             FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                             WHERE        TRCODE = 8 AND CANCELLED = 0)
                          UNION ALL
                          (SELECT        STOCKREF, AMOUNT, DATE_
                           FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                           WHERE        TRCODE = 8 AND CANCELLED = 0)) QQ
WHERE        QQ.DATE_ > CAST(DATEADD(DAY, - 180, GETDATE()) AS DATE)
GROUP BY QQ.STOCKREF
HAVING        SUM(QQ.AMOUNT) > 0)
UNION ALL
(SELECT        QQ.STOCKREF, 0 AS UC, 0 AS ALTI, SUM(QQ.AMOUNT) AS DOKUZ
 FROM            ((SELECT        STOCKREF, AMOUNT, DATE_
                             FROM            [UNIVERSALDB].[dbo].LG_011_08_STLINE
                             WHERE        TRCODE = 8 AND CANCELLED = 0)
                          UNION ALL
                          (SELECT        STOCKREF, AMOUNT, DATE_
                           FROM            [UNIVERSALDB].[dbo].LG_011_07_STLINE
                           WHERE        TRCODE = 8 AND CANCELLED = 0)) QQ
WHERE        QQ.DATE_ > CAST(DATEADD(DAY, - 270, GETDATE()) AS DATE)
GROUP BY QQ.STOCKREF
HAVING        SUM(QQ.AMOUNT) > 0)) KK
GROUP BY KK.STOCKREF

Kodun Çalışma Mantığı (Adım Adım)

Analiz Ekle/Düzenle

Henüz bu nesne için bir analiz girilmemiş.

İlk Analizi Ekle