Home Forums SQL Server 2005 SQL Server 2005 General Discussion INSERT INTO from one table to another table show duplicate row ??? WHY RE: INSERT INTO from one table to another table show duplicate row ??? WHY

  • April 22, 2018 at 4:04 pm

    #1987809

    mrceski - Sunday, April 22, 2018 3:09 PM

    You mean check existing records before INSERTI NTO (transfer from TableIzlezDneven to Tablelzlez) or after INSERT INTO.

    You first need to ensure that there are no duplicates in the TableIzlezDneven table itself.  Then you need to see if any rows in the TableIzlezDneven table already exist in the Tablelzlez.

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