Düzenle: SP_STR_DEPO_OZET_TABLOLARI_REFRESH

İ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

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

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

İptal Nesneyi Sil