• If it can load over midnight then you might have a problem.

    Just a thought but cant you alter the default constraint at the start of each load process so that rather than doing a GetDate() it uses a fixed date for that batch.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices