Hi everyone,
I am hoping that one of the SQL gurus here can help me.
I am trying to create a SQL Query to pull today's exchange rate per customer and I have this:
SELECT
A.EXGTBLID,
A.CURNCYID,
A.EXCHDATE,
A.XCHGRATE,
B.CUSTNMBR
FROM VIDYO.dbo.RM00101 B
INNER JOIN DYNAMICS.dbo.MC00100 A ON A.CURNCYID = B.CURNCYID
WHERE A.EXGTBLID = 'EUR-USD-AVG '
and A.CURNCYID = 'EUR '
AND A.EXCHDATE >= DATEADD(day, -1, convert(date, GETDATE()))
The query runs without errors but it does not show any data. It runs the entire table if I run without filters.
Can you help?
Paul Chacko