Post reply

Stored Procedure that joins tables and accepts a parameter to filter the result

  • April 20, 2020 at 5:04 pm

    #3744736

    kaj wrote:

    I don't know that we know that it's Social Security Numbers in clear text, do we? We only know that the name of the column is SSN, I think. It could theoretically contain anything. 🙂  Including a properly scrambled Social Security Number.

    But, sure, it would be a very bad design if it does indeed use clear-text SSN information as primary and foreign key!

    We actually do know.  The information comes from a previous post on this very subject.  The justification was that it was only being used for an "in-house" application.

    --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 post 31 (of 30 total)

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