• David Burrows (5/21/2008)


    Keep think about submitting something but can't think of anything that ain't already been done 🙁

    Actually.... everything I've written about is NOT new... Tally table is old hat... has been for a long time. I didn't even invent it. But there are a lot of folks out there that knew nothing of it and, it never hurts to see how other people explain the same thing.

    I saw one article by a fellow recently. He wrote about a handful of (I thought) very well known undocumented stored procedures like sp_MSForEachTable. Some folks made some pretty nasty comments about writting about something so obvious. But, to those that don't know, it's no so obvious. Sure, people can search for such things, but like all such research, most folks need to know that such a thing even exists before they can do a search.

    I've been following your posts for years, David... you'd write a great article even if it was on something "obvious"... you have the "knack".

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