Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    41

    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?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SELECT * FROM YESTERDAY
    MINUS
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •