/* ============================================================
   REFRESH (DAILY)
   STR_DEPO_01..08 tablolarini TRUNCATE edip yeniden doldurur.
   Tablolarin CREATE/INDEX isleri için:
   dbo.SP_STR_DEPO_OZET_TABLOLARI_CREATE
   ============================================================ */
CREATE   PROC dbo.SP_STR_DEPO_OZET_TABLOLARI_REFRESH
AS
BEGIN
    SET NOCOUNT ON;

    -- güvence: tablolar yoksa olustur
    --EXEC dbo.SP_STR_DEPO_OZET_TABLOLARI_CREATE;

    TRUNCATE TABLE dbo.STR_DEPO_01;
    INSERT INTO dbo.STR_DEPO_01 (DATE_, ONHAND, STOCKREF)
    SELECT DATE_, ONHAND, STOCKREF
    FROM LV_011_01_STINVTOT
    WHERE INVENNO = 0;

    TRUNCATE TABLE dbo.STR_DEPO_02;
    INSERT INTO dbo.STR_DEPO_02 (DATE_, ONHAND, STOCKREF)
    SELECT DATE_, ONHAND, STOCKREF
    FROM LV_011_02_STINVTOT
    WHERE INVENNO = 0;

    TRUNCATE TABLE dbo.STR_DEPO_03;
    INSERT INTO dbo.STR_DEPO_03 (DATE_, ONHAND, STOCKREF)
    SELECT DATE_, ONHAND, STOCKREF
    FROM LV_011_03_STINVTOT
    WHERE INVENNO = 0;

    TRUNCATE TABLE dbo.STR_DEPO_04;
    INSERT INTO dbo.STR_DEPO_04 (DATE_, ONHAND, STOCKREF)
    SELECT DATE_, ONHAND, STOCKREF
    FROM LV_011_04_STINVTOT
    WHERE INVENNO = 0;

    TRUNCATE TABLE dbo.STR_DEPO_05;
    INSERT INTO dbo.STR_DEPO_05 (DATE_, ONHAND, STOCKREF)
    SELECT DATE_, ONHAND, STOCKREF
    FROM LV_011_05_STINVTOT
    WHERE INVENNO = 0;

    TRUNCATE TABLE dbo.STR_DEPO_06;
    INSERT INTO dbo.STR_DEPO_06 (DATE_, ONHAND, STOCKREF)
    SELECT DATE_, ONHAND, STOCKREF
    FROM LV_011_06_STINVTOT
    WHERE INVENNO = 0;

    TRUNCATE TABLE dbo.STR_DEPO_07;
    INSERT INTO dbo.STR_DEPO_07 (DATE_, ONHAND, STOCKREF)
    SELECT DATE_, ONHAND, STOCKREF
    FROM LV_011_07_STINVTOT
    WHERE INVENNO = 0;

    TRUNCATE TABLE dbo.STR_DEPO_08;
    INSERT INTO dbo.STR_DEPO_08 (DATE_, ONHAND, STOCKREF)
    SELECT DATE_, ONHAND, STOCKREF
    FROM LV_011_08_STINVTOT
    WHERE INVENNO = 0;
END;