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

  • 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?

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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • This is resolved. Thanks.

  •  

    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...

  • 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)
    Intro to Tally Tables and Functions

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

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