Glad to hear it's (mostly) doing what you're looking for.  If I understand correctly, you only want to see all records for a given week where there's been a change...

Is this what you're looking for?

select * from SampleData1
 where date in (
    select distinct sd1.date
      from SampleData1 sd1
...

I needed the same data you did a couple years ago, but we bought something specifically for MS Dynamics Ax.

However, this site has csv files it appears for both the...

If both servers are SQL Server, I'd be tempted to use a linked server to write one query joining the two tables/queries.

The instructions in this thread worked well for me, however I got burned by having special characters in the sftp site's password ... in particular the "%" sign.

When...