Alexa.com 190746 (World) - 4615 (TR)
0 Üye ve 1 Ziyaretçi konuyu incelemekte.
SELECT TOP (100) PERCENT CLCARD.CODE, CLCARD.DEFINITION_, PT.DATE_, PT.TRCODE, PT.MODULENR, SUM(ISNULL(CASE WHEN GETDATE() < PT.DATE_ + 1 THEN CASE WHEN PT.TRCODE = 3 THEN - PT.TOTAL WHEN PT.TRCODE IN ( THEN CASE WHEN PT.TRCURR = 0 THEN PT.TOTAL ELSE 0 END END END, 0)) AS 'SATIS_TL_TUTAR'FROM dbo.LG_117_01_CSCARD AS CSCARD LEFT OUTER JOIN dbo.LG_117_01_PAYTRANS AS PT RIGHT OUTER JOIN dbo.LG_117_01_CSTRANS AS CSTRANS INNER JOIN dbo.LG_117_CLCARD AS CLCARD ON CSTRANS.CARDREF = CLCARD.LOGICALREF ON PT.CARDREF = CLCARD.LOGICALREF ON CSCARD.LOGICALREF = CSTRANS.CSREFGROUP BY PT.TRCODE, PT.MODULENR, CSCARD.DOC, CLCARD.CODE, CLCARD.DEFINITION_, PT.DATE_HAVING (PT.TRCODE IN () AND (PT.MODULENR IN (4))ORDER BY 'SATIS_TL_TUTAR' DESC