on 06-15-2009 5:38 PM
Estimados colegas:
Tengo esta consulta:
SELECT T0.DocNum as 'No. en SAP', T0.NumAtCard as 'Contrato', T0.DocTotal, ((T0.GrosProfit/T0.DocTotal)*100) as '%Ganancia Bruta' FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocStatus = 'o' and T1.Dscription Like '%%nilo%%'
quiero establecer que muestre que la Ganancia Bruta es menor a 26.
Les voy agradecer mucho que me ayuden.
Saludos
agrega al WHERE ((T0.GrosProfit/T0.DocTotal)*100)<26
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
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.