How to compare current data with the historical one?

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.

• Status: Open
• Question Views: 1086
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Rocky Class 0 points N/A #106164

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.

About Rocky Class

Questions
4

Answers
15

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 01/26/2012
• Question Category: Misc Databases