/* ============================================================
   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;