• pawankkmr 41145 (4/30/2015)


    Check out puzzles @

    http://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/%5B/quote%5D

    That's pretty cool. One recommendation would be that if anyone wants to use XML to do a split, you might not want to work for them. 😀

    My other recommendation would be that it would really be helpful to neophytes if you provided code to generate, say, a million rows of sample data so that people can also learn about how to make such things fast.

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