Post reply

How Many Sales for Each Year?

  • September 2, 2020 at 12:00 am

    #3775171

    Comments posted to this topic are about the item How Many Sales for Each Year?

  • September 2, 2020 at 3:15 am

    #3785415

    BWAAA-HAAAAA!!!  All the answers are incorrect... the correct answer is "This is easy to do in T-SQL... why don't you stick with that"? 😀

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

  • September 2, 2020 at 1:05 pm

    #3785568

    I really enjoy these quick, 1-question distractions, especially when I get them right.

    Since I'm such a noob, and have NO idea about 99% of the questions here, I've made a personal rule that I can Google one question about your question (but not your exact question). After that it's educated guesswork, sometimes process of elimination.

    For this one I Googled "R dataframe dplyr" and the returned search results contained the only clue I needed: dplyr makes '$' unnecessary.

    • This reply was modified 3 years, 7 months ago by  klwls.

  • September 2, 2020 at 2:14 pm

    #3785613

    That is really interesting, learned something new today, thanks Steve.

    Agree with Jeff, though...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • September 2, 2020 at 3:58 pm

    #3785655

    I ran into this and was surprised. The syntax is strange, but what a quick easy way to aggregate.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply