Genel Bilgiler
SQL Server
View
✅ Etkilenmez
23.12.2025 07:15
23.12.2025 16:10
İstatistikler
0
Kod Analizi
33
Satır
10
Kullandığı
1
Kullanan
→ Kullandığı Nesneler (10)
USES_VIEW
USES_VIEW
USES_VIEW
USES_VIEW
USES_VIEW
USES_VIEW
USES_VIEW
USES_VIEW
USES_VIEW
USES_VIEW
← Kullanan Nesneler (1)
USES_VIEW
→ Bağımlılık Ağacı
- CARI_AYLIK_TEK_CEKIMUSES_VIEW
- CARI_AYLIK_TAKSITLI_CEKIMUSES_VIEW
- CARI_AYLIK_NAKIT_ODEMEUSES_VIEW
- CARI_AYLIK_SATISLARUSES_VIEW
- CARI_AYLIK_TOPLAM_ODEMEUSES_VIEW
- CARI_AYLIK_TEK_CEKIM_SIFIRUSES_VIEW
- CARI_AYLIK_TAKSITLI_CEKIM_SIFIRUSES_VIEW
- CARI_AYLIK_NAKIT_ODEME_SIFIRUSES_VIEW
- CARI_AYLIK_TOPLAM_ODEME_SIFIRUSES_VIEW
- CARI_AYLIK_SATISLAR_SIFIRUSES_VIEW
← Etki Ağacı
- CARI_AYSONU_HESAPLAMAUSES_VIEW
Tam SQL Kodu
CREATE VIEW dbo.CARI_TUM_ISLEM_TOPLAMLARI
AS
SELECT * FROM
(
(SELECT CLIENTREF, MONTH_, SUM(KKTEK) AS KKTEK, SUM(KKTAK) AS KKTAK, SUM(NAKIT) AS NAKIT, SUM(TOPODM) AS TOPODM, SUM(IADE) AS IADE, SUM(SATIS) AS SATIS, SUM(TOPSAT) AS TOPSAT, SUM(TOPODM)-SUM(TOPSAT) AS DURUM FROM
(
(SELECT CLIENTREF, 0 AS MONTH_, TUTAR AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TEK_CEKIM_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, TUTAR AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TAKSITLI_CEKIM_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, 0 AS KKTAK, TUTAR AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_NAKIT_ODEME_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, TUTAR AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TOPLAM_ODEME_SIFIR)
UNION ALL
(SELECT CLIENTREF, 0 AS MONTH_, 0 AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, IADE, SATIS, TUTAR AS TOPSAT FROM dbo.CARI_AYLIK_SATISLAR_SIFIR)
)QQ
GROUP BY QQ.CLIENTREF, QQ.MONTH_)
UNION ALL
(SELECT CLIENTREF, MONTH_, SUM(KKTEK) AS KKTEK, SUM(KKTAK) AS KKTAK, SUM(NAKIT) AS NAKIT, SUM(TOPODM) AS TOPODM, SUM(IADE) AS IADE, SUM(SATIS) AS SATIS, SUM(TOPSAT) AS TOPSAT, SUM(TOPODM)-SUM(TOPSAT) AS DURUM FROM
(
(SELECT CLIENTREF, MONTH_, TUTAR AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TEK_CEKIM)
UNION ALL
(SELECT CLIENTREF, MONTH_, 0 AS KKTEK, TUTAR AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TAKSITLI_CEKIM)
UNION ALL
(SELECT CLIENTREF, MONTH_, 0 AS KKTEK, 0 AS KKTAK, TUTAR AS NAKIT, 0 AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_NAKIT_ODEME)
UNION ALL
(SELECT CLIENTREF, MONTH_, 0 AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, TUTAR AS TOPODM, 0 AS IADE, 0 AS SATIS, 0 AS TOPSAT FROM dbo.CARI_AYLIK_TOPLAM_ODEME)
UNION ALL
(SELECT CLIENTREF, MONTH_, 0 AS KKTEK, 0 AS KKTAK, 0 AS NAKIT, 0 AS TOPODM, IADE, SATIS, TUTAR AS TOPSAT FROM dbo.CARI_AYLIK_SATISLAR)
)QQ
GROUP BY QQ.CLIENTREF, QQ.MONTH_)
)TT