I have the following problem.
The system I'm working on loads files from outside and uses the information to validate and update itself. The database is run on SQL7.0.
The problem is that a new process demands that we load 2 text files into a table so we can validate information on the user's level. The two files have the same layout, but one of the files includes outdated information which we do not want to load. The second file to be loaded has the up to date information that is outdated in the first file.
Confused yet?!?
What we are trying to do:
Remove the outdated data (which is easily identified) from the first file and then append the information from the second file. The whole process of course should be automatic and without user intervention.
The system I'm working on loads files from outside and uses the information to validate and update itself. The database is run on SQL7.0.
The problem is that a new process demands that we load 2 text files into a table so we can validate information on the user's level. The two files have the same layout, but one of the files includes outdated information which we do not want to load. The second file to be loaded has the up to date information that is outdated in the first file.
Confused yet?!?
What we are trying to do:
Remove the outdated data (which is easily identified) from the first file and then append the information from the second file. The whole process of course should be automatic and without user intervention.