Sumatoria en sqll
Publicado por Wichi (6 intervenciones) el 25/07/2019 21:36:20
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
select COUNT(A.CCUNUMCUE) CANTIDAD,SUM(CSATOTHOY) SALDO from ACMCC_0619 A
INNER JOIN AAMPR_0619 P ON A.CCU_PRODU=P.ACO_PRODU
WHERE (CASE WHENRIGHT((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),2)<20 THEN '20' ELSE '19' END)
+RIGHT((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),2)
+'/'+SUBSTRING((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),3,2)
+'/'+
LEFT((RIGHT(('00'+CAST(CFEULTTRA AS VARCHAR(6))),6)),2) < '2018/03/18' AND CCOESTCUE=2 AND A.ESTADO='A' AND P.ESTADO='A'
Valora esta pregunta
-1