on 03-29-2011 3:27 PM
Buenos dias,
Alguno de ustedes podrá guiarme de como hacer una consulta para obtener los clientes de mayor consumo en un determinado periodo? algo a similar a clasificar las clientes ABC del mes.
Gracias.
Hola Quintaro
Prueba este Query
SELECT TOP 10 T0.CardCode, T0.CardName, SUM(T0.DocTotal)'Facturado'
FROM OINV T0
WHERE T0.DocDate BETWEEN '20110101' AND '20110131'
GROUP BY T0.CardCode, T0.CardName, T0.DocTotal
ORDER BY T0.DocTotal DESC
Saludos
Edited by: Floyola on Mar 29, 2011 10:36 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Pruebala asi Quintaro
SELECT TOP 10 T0.CardCode, T0.CardName, SUM(T0.DocTotal-T1.DocTotal)'Facturado'
FROM OINV T0
INNER JOIN ORIN T1 ON T1.CardCode = T0.CardCode
WHERE T0.DocDate BETWEEN '20110101' AND '20110131' AND T1.DocDate BETWEEN '20110101' AND '20110131'
GROUP BY T0.CardCode, T0.CardName, T0.DocTotal
ORDER BY 3 DESC
Slds
Edited by: Floyola on Mar 29, 2011 10:55 AM
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.