on 05-13-2011 3:57 PM
Colegas,
Tengo la siguiente consulta:
declare @t numeric (9,2);
set @t=(SELECT T3.[Rate]
FROM OINV T0 INNER JOIN RCT2 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN ORCT T2 ON T1.DocNum = T2.DocEntry INNER JOIN ORTT T3 ON T2.DocDate = T3.RateDate INNER JOIN OPRJ T4 ON T0.Project = T4.PrjCode
WHERE T4.[PrjName] = '[%0]');
select @t
si tengo varios pagos (tabla: orct) cómo puedo traer únicamente el tipo de cambio de la última fecha de pago?
Saludos!
hola, Intenta probar con la siguiente query:
select RateDate, Currency, Rate from ORTT where RateDate=(Select max(DocDate) from ORCT)
saludos.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
intenta de la siguiente manera:
SELECT T3.Rate
FROM OINV T0 INNER JOIN
RCT2 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN
ORCT T2 ON T1.DocNum = T2.DocEntry INNER JOIN
ORTT T3 ON T2.DocDate = T3.RateDate INNER JOIN
OPRJ T4 ON T0.Project = T4.PrjCode
WHERE T4.PrjName like '%0' and T3.RateDate=(select max(DocDate) from ORCT)
a mi me funciona perfectamente, espero que a ti también.
Saludos.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
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.