Post reply

How to make sure for each ID there was no records exists with text

  • March 14, 2023 at 2:48 am

    #4160372

    Oh, like that! I was going to say this question reminded me of the "Which pilots can fly all the planes in the hangar?" question from SQL for Smarties (I think).

  • March 14, 2023 at 4:32 am

    #4160393

    jcelko212 32090 wrote:

    And this is why we want posters to always put the DDL for their tables where we can see them. After 30+ years of doing SQL and RDBMS, I would think people understand this is not an option, but a definition of a table! Oh, oh well, we still have id-iots and tibbles in these postings. It's even worse over on Quora; we have postings for people asking how many primary keys a table can have. 🙁

    Heh... while I agree with all that, it's still incorrect code for the problem you intended to solve, Joe.

    --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 2 posts - 16 through 16 (of 16 total)

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