CREATE VIEW dbo.CARI_AY_ICI_ODEMELER
AS
SELECT        QQ.CLIENTREF, QQ.MONTH_, QQ.DATE_, QQ.GUN, SUM(TUTAR) OVER (PARTITION BY QQ.CLIENTREF, QQ.MONTH_
ORDER BY QQ.GUN) AS TUTAR
FROM            (SELECT        CLIENTREF, MONTH_, DATE_, DATEDIFF(DAY, DATEADD(MONTH, DATEDIFF(MONTH, 0, DATE_), 0), CAST(DATE_ AS DATE)) AS GUN, TRNET AS [TUTAR]
                          FROM            LG_011_07_CLFLINE
                          WHERE        TRCODE IN (1, 20, 70) AND CANCELLED = 0) QQ