Calculating Stock Returns Using the ROW_NUMBER function and CTEs

Question

Calculating Stock Returns Using the ROW_NUMBER function and CTEs

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

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

jshahan SSCarpal Tunnel Points: 4622 More actions · Answer 1

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.

eephus101 SSC Enthusiast Points: 138 More actions · Answer 2

Grasshopper,

Now that would be a cool article!

Thanks for the feedback,

-John

John R

esteban alvino quispe SSC Rookie Points: 39 More actions · Answer 3

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

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

gitmo Old Hand Points: 379 More actions · Answer 5

gitmo

Old Hand

Points: 379

October 20, 2011 at 11:38 am

#1397574

Well written article. Thanks.:hehe:

Calculating Stock Returns Using the ROW_NUMBER function and CTEs

Cookies on SQLServerCentral