Genel Bilgiler
SQL Server
View
✅ Etkilenmez
23.12.2025 07:15
23.12.2025 16:10
İstatistikler
0
Kod Analizi
27
Satır
8
Kullandığı
1
Kullanan
→ Kullandığı Nesneler (8)
REFERENCES
REFERENCES
REFERENCES
REFERENCES
REFERENCES
REFERENCES
REFERENCES
REFERENCES
← Kullanan Nesneler (1)
USES_VIEW
→ Bağımlılık Ağacı
- STR_DEPO_01REFERENCES
- STR_DEPO_02REFERENCES
- STR_DEPO_03REFERENCES
- STR_DEPO_04REFERENCES
- STR_DEPO_05REFERENCES
- STR_DEPO_06REFERENCES
- STR_DEPO_07REFERENCES
- STR_DEPO_08REFERENCES
← Etki Ağacı
- SP_STR_MALZEME_RAPORUUSES_VIEW
- STR_RAPORUCALLS_SP
- STR_RAPORUCALLS_SP
Tam SQL Kodu
CREATE VIEW dbo.STR_DEPO_HAREKETLERI
AS
SELECT DATE_, ONHAND, STOCKREF
FROM (SELECT DATE_, ONHAND, STOCKREF
FROM dbo.STR_DEPO_08
UNION ALL
SELECT DATE_, ONHAND, STOCKREF
FROM dbo.STR_DEPO_07
UNION ALL
SELECT DATE_, ONHAND, STOCKREF
FROM dbo.STR_DEPO_06
UNION ALL
SELECT DATE_, ONHAND, STOCKREF
FROM dbo.STR_DEPO_05
UNION ALL
SELECT DATE_, ONHAND, STOCKREF
FROM dbo.STR_DEPO_04
UNION ALL
SELECT DATE_, ONHAND, STOCKREF
FROM dbo.STR_DEPO_03
UNION ALL
SELECT DATE_, ONHAND, STOCKREF
FROM dbo.STR_DEPO_02
UNION ALL
SELECT DATE_, ONHAND, STOCKREF
FROM dbo.STR_DEPO_01) AS QQ