Genel Bilgiler
SQL Server
View
✅ Etkilenmez
23.12.2025 07:15
23.12.2025 16:10
İstatistikler
0
Kod Analizi
23
Satır
5
Kullandığı
1
Kullanan
→ Kullandığı Nesneler (5)
REFERENCES
REFERENCES
REFERENCES
REFERENCES
REFERENCES
← Kullanan Nesneler (1)
USES_VIEW
→ Bağımlılık Ağacı
- SP_STR_ALIM_OZET_TABLOLARI_OLUSTURREFERENCES
- STR_ALIM_05REFERENCES
- STR_ALIM_06REFERENCES
- STR_ALIM_07REFERENCES
- STR_ALIM_08REFERENCES
- STR_ALIM_05REFERENCES
- STR_ALIM_06REFERENCES
- STR_ALIM_07REFERENCES
- STR_ALIM_08REFERENCES
← Etki Ağacı
- SP_STR_MALZEME_RAPORUUSES_VIEW
- STR_RAPORUCALLS_SP
- STR_RAPORUCALLS_SP
Tam SQL Kodu
/* ============================================================
NOT:
Asagidaki STR_ALIM_05 / STR_ALIM_06 / STR_ALIM_07 / STR_ALIM_08 tablolari,
orijinal LOGO STLINE tablolarindan SELECT INTO ile türetilmis özet tablolardir.
Türetme / Yenileme Procedure:
dbo.SP_STR_ALIM_OZET_TABLOLARI_OLUSTUR
============================================================ */
CREATE VIEW dbo.STR_ALIM_TARIHLERI
AS
SELECT STOCKREF, DATE_, INVOICEREF, MIKTAR
FROM (SELECT STOCKREF, DATE_, INVOICEREF, MIKTAR
FROM dbo.STR_ALIM_08
UNION ALL
SELECT STOCKREF, DATE_, INVOICEREF, MIKTAR
FROM dbo.STR_ALIM_07
UNION ALL
SELECT STOCKREF, DATE_, INVOICEREF, MIKTAR
FROM dbo.STR_ALIM_06
UNION ALL
SELECT STOCKREF, DATE_, INVOICEREF, MIKTAR
FROM dbo.STR_ALIM_05) AS QQ