Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jacob Sebastian Generating Missing Dates and Numbers RE: Generating Missing Dates and Numbers

  • February 6, 2008 at 7:33 am

    #775582

    GSquared (2/6/2008)

    Yet again, I have to say this is clever, but a Numbers table is better.

    Yes, if you for some reason need to create a list of sequential numbers on the fly, this CTE is probably the fastest means of doing so. It certainly is at least A fast means of doing so. But having an actual Numbers table, with a clustered index on it, is MUCH better.

    (Yes, this is the third or fourth time I've written on this exact subject. But for whatever reason, it keeps coming up.)

    Spot on, G... didn't see your post as I was writting mine.

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