Merhaba vade ayı geçenlere 0 yazdırmak istiyorum ançak bi türlü yapamadım
örnek vereyim : şuan 11 aydayız bu aydan küçük ayları 0 yapsın ançak söyle bir sorun var 2018 de ocak yani ay 1 olanlarda sıfır oluyor şuanki ayı baz aldığı için nasıl bir yol izlemem gerek
SELECT LG_117_01_PAYTRANS.LOGICALREF, LG_117_CLCARD.CODE AS 'M.KODU', LG_117_CLCARD.DEFINITION_ AS 'M.ÜNVANI', LG_117_01_PAYTRANS.DATE_ AS 'VADESİ',
LG_117_01_PAYTRANS.TOTAL AS 'TUTAR', Sum(DATEDIFF(D,GETDATE(),LG_117_01_PAYTRANS.DATE_)) AS 'GECİKMİŞ',
MONTH(LG_117_01_PAYTRANS.DATE_) AS 'VADE AYI',
YEAR(LG_117_01_PAYTRANS.DATE_) AS [VADE YILI],
(CASE WHEN MONTH (LG_117_01_PAYTRANS.DATE_) = 1 THEN LG_117_01_PAYTRANS.TOTAL END) AS [OCAK],
CASE WHEN MONTH(GETDATE()) > MONTH( LG_117_01_PAYTRANS.DATE_) THEN 0 ELSE LG_117_01_PAYTRANS.TOTAL END AS TUTAR
FROM dbo.LG_117_01_PAYTRANS LG_117_01_PAYTRANS, dbo.LG_117_CLCARD LG_117_CLCARD
WHERE LG_117_CLCARD.LOGICALREF = LG_117_01_PAYTRANS.CARDREF AND (LG_117_01_PAYTRANS.CANCELLED=0.0) AND LG_117_CLCARD.CODE='120.01.00186'
GROUP BY LG_117_CLCARD.CYPHCODE, LG_117_CLCARD.CODE, LG_117_CLCARD.DEFINITION_, LG_117_01_PAYTRANS.DATE_, LG_117_01_PAYTRANS.TOTAL, LG_117_CLCARD.SPECODE3,
LG_117_01_PAYTRANS.PAID, LG_117_01_PAYTRANS.PAIDINCASH, LG_117_01_PAYTRANS.SIGN, LG_117_01_PAYTRANS.FICHEREF,LG_117_01_PAYTRANS.LOGICALREF
HAVING (LG_117_01_PAYTRANS.PAID=0.0) AND (LG_117_01_PAYTRANS.PAIDINCASH=0) AND (LG_117_01_PAYTRANS.SIGN=0) AND (LG_117_01_PAYTRANS.FICHEREF>0)
ORDER BY LG_117_CLCARD.DEFINITION_
