[thelist] SQL: finding "new" records in a table

Luther, Ron Ron.Luther at hp.com
Tue Sep 4 12:50:20 CDT 2007


Hi Judah,


Hope it's not as soggy up there as here!

Sorry, haven't give this a ton of thought. A question and an idea
though.

Question - How are you handling cancelled appointments?  Are you
receiving a blank record for that timeslot?  Just wondering how you know
to delete an existing appointment in the absence of an 'update' record.

Idea - How about a 'delsert' methodology?  If your csv files are
complete appointment records for each individual office then, upon
receipt, you can delete all records for that office and insert all of
the new records.  Probably faster than any search & update rigamarole.
Would handle cancellations as well.  Might wanna save off a prior gen
(or use one of those 'deleted' flags or timestamps with an out-of-cycle
cleanup process) to allow you to revert data if you get a "short" file
from some office some day.


HTH,
RonL.



More information about the thelist mailing list