DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
paulchacko 1/30/2017 2:35:18 PM

Exchange rate per customer report

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

Version: GP 10
Section: Dynamics GP