Excuse the delay in my reply to your welcomed response to my post.
Let me say that after my post I spent several more hours immersed in your guide and trialing and “erroring” your program. I now must admit my problem was more my not having used SQL in a decade and trying to get your program to do more for which it was intended.
I researched building code violations as pertains organization I volunteer. So I came up with Excel list of around a hundred. A month later I ran the same research. I was looking for a freeware program that would compare Excel files and point out the particular
gained or lost violations. I eventually achieved this with your SqlDiffFramework by narrowing comparison to violation number column, solely. Unfortunately, I do not know how to get it to send to a separate file the changes in violations over the time period
(old versus new files)
I note that I found that MS Access has a Query Wizard that appears to do what I want and I include SQLview sample below:
LEFT JOIN OLDvios ON vios120812.[VioID] = OLDvios.[VioID]
WHERE (((OLDvios.VioID) Is Null));
This outputs a usable table of “new” violations with associated, identifying building information that did not exist in old research that need to be addressed (deficiencies to be fixed or removed by maintenance crew work order).
I am now thinking, thanks to you and your program to actually learn how to get the research onto SQL server so that I can run query both directions to give me the accurate list of violation changes I seek.
Allow me to note your program is a FINE piece of compact programming!! Thank you very much for your effort and gracious altruism for placing it in the public domain. More astounding is your reply and concern!
I certainly have been improved and better directed by your software gift and just want you to know how it helped me, personally.