• Lynn Pettis (10/3/2013)


    enriquezreyjoseph (10/2/2013)


    Jeff Moden (10/2/2013)


    enriquezreyjoseph (10/1/2013)


    Hi Everyone..I hope everyone is having a nice day:-)

    Is this right if i will do my project this way?

    Please see my attachment

    If it's strictly an ETL project, maybe. Otherwise, probably not.

    What do you mean ETL project??...

    "Every Person has it's own weaknesses, be brave even though you are not, no one can tell the difference" ~ Sir Bernard Tan

    ETL - Extract, Transform, Load

    Usually done when moving data from OLTP databases to DW databases.

    Or moving data from external sources to databases.

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