• chris_masiero (10/6/2013)


    I really don't know if being an expert is even required for 95% of jobs.

    Correct... but I'm thinking that they expect someone who's applying for a job that involves the use of T-SQL can actually do the job.

    I might even fail a 'test' in an interview if they wanted me to write something of the top of my head that involves some of the more exotic SQL.

    But I'll bet you could write a joined UPDATE for two simple tables off the top of your head. I've interviewed a whole lot of people that don't even know where to begin. 😛

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