Home Forums SQL Server 2008 T-SQL (SS2K8) how to fetch records from multiple tables RE: how to fetch records from multiple tables

  • December 28, 2012 at 10:04 pm

    #1572296

    Sean Lange (12/28/2012)

    First of all, SSN have and will be reused. When people die their SSN gets recycled into the available pool.

    While it is true that a person can change their SSN, it's a myth that SSNs are recycled. Please see Q20 on the following webpage which is on the official Social Security website.

    http://www.socialsecurity.gov/history/hfaq.html

    There was one incident many years ago where some secretary had her SS card used as a demo card in wallets and some huge number of people claimed it as their own, but Social Security numbers have not been reused to date.

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