Compare Two Data-Sets
Posted on 2011-03-14
I am modifying an app that was handed on to me...
I need to compare insurance claims at two points in time. I only need to report claims that have changed in value from Date 1 to Date 2 based on certain values; i.e. Total_Paid for example.
I have two stored procedures that pull claim data as of 1/1/2010 and then another that pulls the claim data as of 1/1/2011. I then want to compare Total_Paid_Amount_2010 to Total_Paid_Amount_2011. If its different, I write both records to a text file.
I'm not familiar with datasets, datatables, etc. Is this the best way to do this? Could anyone provide a generic example of obtaining the dataset, putting into data tables and then comparing the data. I'm under a very tight time constraint....