Inserting a new row into a table using a cursor

  • ThomasRushton - Wednesday, November 28, 2018 5:40 AM

    gvoshol 73146 - Wednesday, November 28, 2018 5:22 AM

    jcelko212 32090 - Tuesday, November 27, 2018 7:44 AM

    I just happen to like a length of nine or 10 digits, since it matches the SSN or DUNS or several other "standard identifiers" and might match existing forms and screens.

    SSN is truly awful. But it's also very common. Most of the duplicate Social Security numbers. We've got are from illegals stealing them. I had a friend who was teaching at UCLA at the same time he was supposed to be washing dishes in San Diego. The result was he got dinged for two incomes by the IRS. The old Social Security number used to break into groups, each of which had meaning, but they abandon that a few years ago so it's just a random nine digits today.

    The new Medicare number is done in groups of four, three, four text and digits; I have no idea how it's created. But I've seen commercially is that people want to use the customer's email as is an identifier. People actually seem to keep their email address for a long time, and you can be verified by, well, sending an email.

    Please post DDL and follow ANSI/ISO standards when asking for help. 

  • jcelko212 32090 - Wednesday, November 28, 2018 8:26 AM

    ThomasRushton - Wednesday, November 28, 2018 5:40 AM

    gvoshol 73146 - Wednesday, November 28, 2018 5:22 AM

    jcelko212 32090 - Tuesday, November 27, 2018 7:44 AM

    I just happen to like a length of nine or 10 digits, since it matches the SSN or DUNS or several other "standard identifiers" and might match existing forms and screens.

    SSN is truly awful. But it's also very common. Most of the duplicate Social Security numbers. We've got are from illegals stealing them. I had a friend who was teaching at UCLA at the same time he was supposed to be washing dishes in San Diego. The result was he got dinged for two incomes by the IRS. The old Social Security number used to break into groups, each of which had meaning, but they abandon that a few years ago so it's just a random nine digits today.

    The new Medicare number is done in groups of four, three, four text and digits; I have no idea how it's created. But I've seen commercially is that people want to use the customer's email as is an identifier. People actually seem to keep their email address for a long time, and you can be verified by, well, sending an email.

    If you actually read the Social Security Act the SSN isn't supposed to be used for identification.

  • Lynn Pettis - Wednesday, November 28, 2018 8:32 AM

    jcelko212 32090 - Wednesday, November 28, 2018 8:26 AM

    ThomasRushton - Wednesday, November 28, 2018 5:40 AM

    gvoshol 73146 - Wednesday, November 28, 2018 5:22 AM

    jcelko212 32090 - Tuesday, November 27, 2018 7:44 AM

    I just happen to like a length of nine or 10 digits, since it matches the SSN or DUNS or several other "standard identifiers" and might match existing forms and screens.

    SSN is truly awful. But it's also very common. Most of the duplicate Social Security numbers. We've got are from illegals stealing them. I had a friend who was teaching at UCLA at the same time he was supposed to be washing dishes in San Diego. The result was he got dinged for two incomes by the IRS. The old Social Security number used to break into groups, each of which had meaning, but they abandon that a few years ago so it's just a random nine digits today.

    The new Medicare number is done in groups of four, three, four text and digits; I have no idea how it's created. But I've seen commercially is that people want to use the customer's email as is an identifier. People actually seem to keep their email address for a long time, and you can be verified by, well, sending an email.

    If you actually read the Social Security Act the SSN isn't supposed to be used for identification.

    My old SSN card still says that right on the front.

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

  • jcelko212 32090 - Tuesday, November 27, 2018 7:44 AM

    But for a posting, I want people to learn that an identifier is on a nominal scale and cannot be a numeric or pointer value.

    As always, I'll have to strongly disagree with that.

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

  • jcelko212 32090 - Wednesday, November 28, 2018 8:26 AM

    Most of the duplicate Social Security numbers. We've got are from illegals stealing them.

    Please provide documentation for this assertion.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • This was removed by the editor as SPAM

Viewing 6 posts - 16 through 20 (of 20 total)

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