Welsh Corgi (7/8/2012)
The problem is that most of the tables do not have Insert, Modified Date on them so they can't just select on the Datetime stamps.
On the smaller tables I converted their logic to a TRUNCDATE & Fast Load OLE DB.
...had to do similar on a third pty database.
smaller tables...truncate and reload
and if IIRC ended up paying to get modified date columns on larger (excess 1m rows)..then there was still an on going debate about creating relevant index...hey ho 🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day