Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Finding “Active” Rows for the Previous Month (SQL Spackle) RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

  • January 30, 2014 at 8:27 am

    #1684695

    Thomas Abraham (1/30/2014)

    When I went to review this spackle, I found the current rating was "Good". Can't agree. Jeff has, as usual, taken a problem of some import, broken it down into easily digestible steps, provided excellent explanations, and written pretty code to show how to solve it.

    Can I get an "Excellent" people?

    Thanks Jeff. I want to be you someday when I grow up. If I decide it's worth growing up. 😉

    Thank you for the kind words, Thomas. :blush: If I ever need a couple of PR guys for something really important, you'll definitely be one of them.

    Heh... as for "growing up", it's seriously over rated. I'm 61 and I still enjoy being a "kid". MUCH more fun that way. 😛

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