[eluser]sherwoodforest[/eluser]
I would love to be able to limit the data
where is the data coming from?
I get a text file of all leads I can only limit by geography. (It doesn't give me a way to limit to just the ones that changed) so I don't have timestamps or a last updated field, only the current state of the lead.
so it looks like I get to load into temp table
and then do a compare between live table and the temp table to find the modified records
(which should normally be <.01% of the records)