SQLTeam.com | Weblogs | Forums

Prevent the same record from being extracted

Hello,
I have a stored that, with a SELECT (based on some conditions), extract and populate a file to export via FTP.
This stored is scheduled to run 2 times a day.
I have to implement something that when a record is sent (extracted via FTP), must not be
present in the following extraction.
What is the best way to obtain this feature?

Thanks a lot.

Luis

Create a logging table that tracks which rows were sent. Then on extex'tract exclude rows from logging table.But what if that row changes again?

1 Like

If they changes, I'll have to send them again.

L.

Do you have any audit columns on source table for ex modifieddate?