Post reply

Calculating Stock Returns Using the ROW_NUMBER function and CTEs

  • October 18, 2011 at 1:13 pm

    #1396287

    I'm appreciative of the exposure to T-SQL functionality and applications that I rarely use (in this case OVER and CTEs). This is clear and well thought through. I thank you.

  • October 18, 2011 at 1:22 pm

    #1396294

    Grasshopper,

    Now that would be a cool article!

    Thanks for the feedback,

    -John

    John R

  • October 18, 2011 at 1:40 pm

    #1396302

    I have an question,

    Why do you stablish that week number would have to be minor than 53

    in the "IN" Statement.

    Nice Article 🙂

    Best regards

    Thanks

  • October 18, 2011 at 3:51 pm

    #1396368

    Nice real world example. Thanks.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 20, 2011 at 11:38 am

    #1397574

    Well written article. Thanks.:hehe:

Viewing 5 posts - 16 through 19 (of 19 total)

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