on 03-23-2010 3:34 PM
Colegas,
Tengo el siguiente query
SELECT
T1.[CodeBars],
T0.[ItemCode] AS Codigo,
T1.[ItemName],
MAX(T0.DocDate)AS Fecha,
MAX(T0.[CalcPrice]) As Costo_de_Compra,
T0.[Warehouse], T0.[TransType]
FROM .[OINM] T0 INNER JOIN .[OITM] T1 ON T1.[ItemCode] = T0.[ItemCode]
WHERE T0.CalcPrice<>0 AND T0.[TransType]=69 AND (T0.[TransValue] <> 0 OR T0.[InQty] <> 0) and T0.[Warehouse] = '[%0]'
GROUP BY T0.[ItemCode], T1.[ItemName], T0.[Warehouse], T0.[TransType], T1.[CodeBars]
¿Cómo hago para que la fecha sea igual o cercana al 31/Dic/09?
Saludos.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Checa el formato que tienes configurado con la fecha, pero seria algo asi como
where T0.docdate>='20091231' o <='20091231'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.