Merhaba logo üzerinden veri alıyorum
Getdate ile şimdi ki zamanı çekiyorum ançak tarihi geçmiş olanları sınır yapmasını istiyorum
Örnek vereyim
05-07-2017 5000 tl
08-07-2017 6000 tl
09-07-2018 10.000
Getdateyi month ile aya çeviriyorum ayı geçenler sıfır olsun
Ama yıl gelmeyenlerin bakiyesini alsın
MONTH(LG_117_01_PAYTRANS.DATE_) AS 'VADE AYI',
YEAR(LG_117_01_PAYTRANS.DATE_) AS [VADE YILI],
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_
Getdate ile şimdi ki zamanı çekiyorum ançak tarihi geçmiş olanları sınır yapmasını istiyorum
Örnek vereyim
05-07-2017 5000 tl
08-07-2017 6000 tl
09-07-2018 10.000
Getdateyi month ile aya çeviriyorum ayı geçenler sıfır olsun
Ama yıl gelmeyenlerin bakiyesini alsın
MONTH(LG_117_01_PAYTRANS.DATE_) AS 'VADE AYI',
YEAR(LG_117_01_PAYTRANS.DATE_) AS [VADE YILI],
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_