• RonKyle - Thursday, May 18, 2017 7:08 AM

    Often there is a natural key for employees or people.  Often there is not one.  If the natural key exists, it should be used.  If it doesn't, use an identity.

    It sounds like you may have run into an "employee" table that does, in fact, have a natural key.  I've run into a couple myself but none of the could withstand the test of time as a true unique row key.  What have you seen?

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