Düzenle: SP_STR_ALIM_OZET_TABLOLARI_OLUSTUR

İlgili Uygulama

Nesne Türü

Nesne Adı

Bu nesne dönem devrinden etkileniyor mu? (Örn: İçinde _01_ gibi sabit dönem kodu var mı?)

Genel Kullanım Amacı ve Notlar

Tam SQL Kodu

/* ============================================================
   Bu procedure, orijinal LOGO tablolari olan:
   LG_011_05_STLINE, LG_011_06_STLINE, LG_011_07_STLINE, LG_011_08_STLINE
   üzerinden filtrelenmis + gruplanmis "alis özet" tablolarini SELECT INTO ile üretir.

Üretilen tablolar:
   dbo.STR_ALIM_05, dbo.STR_ALIM_06, dbo.STR_ALIM_07, dbo.STR_ALIM_08

Not: Bu tablolar, rapor/hesaplama performansini artirmak için orijinal tablolardan türetilmistir.
   Yeniden üretim/refresh için bu procedure çalistirilmalidir.

Procedure Adi: dbo.SP_STR_ALIM_OZET_TABLOLARI_OLUSTUR
   ============================================================ */
CREATE   PROC dbo.SP_STR_ALIM_OZET_TABLOLARI_OLUSTUR
AS
BEGIN
    SET NOCOUNT ON;

/* =========================
       05 -> STR_ALIM_05
       ========================= */
    IF OBJECT_ID('dbo.STR_ALIM_05', 'U') IS NOT NULL
        DROP TABLE dbo.STR_ALIM_05;

SELECT
        STOCKREF,
        DATE_,
        INVOICEREF,
        SUM(AMOUNT) AS MIKTAR
    INTO dbo.STR_ALIM_05
    FROM LG_011_05_STLINE
    WHERE TRCODE = 1 AND CANCELLED = 0 AND LINETYPE = 0
    GROUP BY STOCKREF, DATE_, INVOICEREF;

CREATE INDEX IX_STR_ALIM_05_STOCKREF_DATE
    ON dbo.STR_ALIM_05 (STOCKREF, DATE_)
    INCLUDE (INVOICEREF, MIKTAR);

CREATE INDEX IX_STR_ALIM_05_INVOICEREF
    ON dbo.STR_ALIM_05 (INVOICEREF)
    INCLUDE (STOCKREF, DATE_, MIKTAR);

/* =========================
       06 -> STR_ALIM_06
       ========================= */
    IF OBJECT_ID('dbo.STR_ALIM_06', 'U') IS NOT NULL
        DROP TABLE dbo.STR_ALIM_06;

SELECT
        STOCKREF,
        DATE_,
        INVOICEREF,
        SUM(AMOUNT) AS MIKTAR
    INTO dbo.STR_ALIM_06
    FROM LG_011_06_STLINE
    WHERE TRCODE = 1 AND CANCELLED = 0 AND LINETYPE = 0
    GROUP BY STOCKREF, DATE_, INVOICEREF;

CREATE INDEX IX_STR_ALIM_06_STOCKREF_DATE
    ON dbo.STR_ALIM_06 (STOCKREF, DATE_)
    INCLUDE (INVOICEREF, MIKTAR);

CREATE INDEX IX_STR_ALIM_06_INVOICEREF
    ON dbo.STR_ALIM_06 (INVOICEREF)
    INCLUDE (STOCKREF, DATE_, MIKTAR);

/* =========================
       07 -> STR_ALIM_07
       ========================= */
    IF OBJECT_ID('dbo.STR_ALIM_07', 'U') IS NOT NULL
        DROP TABLE dbo.STR_ALIM_07;

SELECT
        STOCKREF,
        DATE_,
        INVOICEREF,
        SUM(AMOUNT) AS MIKTAR
    INTO dbo.STR_ALIM_07
    FROM LG_011_07_STLINE
    WHERE TRCODE = 1 AND CANCELLED = 0 AND LINETYPE = 0
    GROUP BY STOCKREF, DATE_, INVOICEREF;

CREATE INDEX IX_STR_ALIM_07_STOCKREF_DATE
    ON dbo.STR_ALIM_07 (STOCKREF, DATE_)
    INCLUDE (INVOICEREF, MIKTAR);

CREATE INDEX IX_STR_ALIM_07_INVOICEREF
    ON dbo.STR_ALIM_07 (INVOICEREF)
    INCLUDE (STOCKREF, DATE_, MIKTAR);

/* =========================
       08 -> STR_ALIM_08
       ========================= */
    IF OBJECT_ID('dbo.STR_ALIM_08', 'U') IS NOT NULL
        DROP TABLE dbo.STR_ALIM_08;

SELECT
        STOCKREF,
        DATE_,
        INVOICEREF,
        SUM(AMOUNT) AS MIKTAR
    INTO dbo.STR_ALIM_08
    FROM LG_011_08_STLINE
    WHERE TRCODE = 1 AND CANCELLED = 0 AND LINETYPE = 0
    GROUP BY STOCKREF, DATE_, INVOICEREF;

CREATE INDEX IX_STR_ALIM_08_STOCKREF_DATE
    ON dbo.STR_ALIM_08 (STOCKREF, DATE_)
    INCLUDE (INVOICEREF, MIKTAR);

CREATE INDEX IX_STR_ALIM_08_INVOICEREF
    ON dbo.STR_ALIM_08 (INVOICEREF)
    INCLUDE (STOCKREF, DATE_, MIKTAR);

END;

Oluşturulma: 23.12.2025 07:15 Son Güncelleme: 23.12.2025 17:28

İptal Nesneyi Sil