05-08-13, 20:17 #1Registered User
- Join Date
- Apr 2013
Unanswered: How to approach the following problem ?
We have a very large excel file that is produced every day by a batch process. We need to report what records were added and which records were removed compared to the file generated on the previous day. The challenge is that there is no sortable field in the list that we could use (such as a creation date), imagine for the sake of this test that there’s only First Name, Last Name and Email in the excel file, and that the ordering is not consistent from one day to the next. How would you approach the problem?
Please let me know how should I approach this problem?
05-08-13, 20:40 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
SELECT * FROM YESTERDAY
SELECT * FROM TODAY;
above can provide partial answer & can be used as basis for complete solution.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.