Home Forums SQL Server 2008 SQL Server Newbies Create Table and Bulk Insert RE: Create Table and Bulk Insert

  • December 18, 2012 at 6:24 am

    #1569528

    urso47 (12/16/2012)

    Great Jeff!!!

    Thanks a lot! I saw it and it seems very, very complex for me to understand rigth away. I will take sometime later on to test the code you provided.

    As soon as I test it, I will let you know.

    Thanks again!!!!

    Andre

    Thanks for the feedback, Andre. When you're reading the code, just remember the simple stuff it's doing. Other than checking for the position of data to make sure the file is formatted correctly, it just ...

    1. Reads the file into a single column.

    2. Parses the header info and pivots it into a single line table.

    3. Parses the detail info and adds the header information to it.

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