Howdy everyone. I am new to dotnet so i wanted to see if something was possible and if so, the easiest way to accomplish this feat.
I want to write a exe that compares to recordsets i will create using SQL statements. Recordset "A" is from the table our users are currently using. Recordset "B" is from a view that shows up to them minute changes (Pulls from muiltiple sources). I will run the exe everynight and this is what I am trying to accomplish. If B has more records than A.... I want to insert the differeneces into the source table from A. The changes would also be written to a log file so the changes would be documented nightly. If A has more records than B... I want to write to a log that notes the missing records so that they can be reviewed later and the user can determine if they need to be processed for deletion. I know the SQL i want to use, but beyond that I am looking for any help to see what type of function or code I would use.
