Home Forums SQL Server 2012 SQL 2012 - General Database import from text/csv file and many to many relationship RE: Database import from text/csv file and many to many relationship

  • I absolutely agree with Erland. There are dozens of ways to skin this cat and this is an excellent opportunity to compare the different methods and learn their strengths and weaknesses. It's always good to have multiple options especially if you run into a picky DBA or some picky company standards.

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