Post reply

Retrieve records added across database (all user table) after a specific date

  • August 9, 2022 at 10:31 am

    #4074328

    I would like a query to retrieve all records that have been added after Monday 8th August across all User tables in a named database where some tables in the database have created date field and many tables don't have created date field, grouped by table name, please?

  • August 9, 2022 at 10:44 am

    #4074331

    If a table does not have DateCreated, how would 'the system' know which of its rows to select?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • August 10, 2022 at 8:00 am

    #4074708

    This is resolved. Thanks.

  • August 10, 2022 at 8:21 pm

    #4075011

     

    Can the poster show us how was the problem resolved. "If a table does not have DateCreated, how would 'the system' know which of its rows to select?"

    Zidar's Theorem: The best code is no code at all...

  • August 11, 2022 at 3:41 am

    #4075071

    fafful wrote:

    This is resolved. Thanks.

    I'm really curious... how did you resolve this, please?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply