>Hi All:
>
>I have been asked to produce a file with 300,000 records for viewing in SharePoint (of which I know little).
>
>Thereafter, instead of rerunning the generation of the file, the SP programmer wants me to produce an update log with Changes, Adds and Deletes. He would then use this file to update the master file.
>
>My idea would be to produce the current copy of the humongous file and then run a compare program that would generate the Update log. It goes without saying that each record has a unique PK.
>
>My questions:
>
>1. Does this appear to be a sound approach?
>2. Is there a quicker way to compare records other than looping thru each field in the record?
>

If you have a table that contains the base records and you want to compare the current records, you can certainly use a query:

SELECT MyRealTable.* ;
   FROM MyRealTable ;
     JOIN MostRecentCopy ;
        ON MyRealTable.PK = MostRecentCopy.PK ;
     WHERE MyRealTable.Field1 <> MostRecentCopy.Field1 ;
             OR MyRealTable.Field2 <> MostRecentCopy.Field2 ;
          .... ;
    INTO CURSOR csrNewChanges

You'll also need queries to find records you've added or deleted. And then, of course, when you're done, your current table becomes the most recent copy.

Tamar