Asked By
Chaya Dixon
0 points
N/A
Posted on - 01/25/2012
Hello Techyv experts
Currently I am building a client’s database that will contain some historical data in some text boxes. I need to compare that current data with the historical data. Is there any way to do so? Please help me.
How to compare current data with the historical one?
Â
hi,
Â
You can compare the data in three different ways.
Â
Database Stored procedure
Â
1) Load the current data in a temp table first.
Â
2) Using Sql statements and string functions compare the data in the text boxes.
Â
Excel sheet
Â
1) If the historical data is less than 65,000 rows you can export them into Excel sheet.
Â
2) Load your current data into the same excel sheet and compare both of them.
Â
Script or Language
Â
1) Using the scripting or programming languages you can read the database having the historical records.
Â
2) write a script to read the current data from the file and then compare the text boxes using string functions in the scripting language.
Â
kindly let me know, if you need further assistance in creating such scripts.