A Stock Price Correlation Matrix
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
2012-05-14
6,514 reads
John Ryle
Calculating Stock Returns Using the ROW_NUMBER function and CTEs
In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue.
2011-10-18
6,893 reads
Blogs
Azure Platform Series: cloudshell code -your (brilliant) online editor
By HeyMo0sh
This post is about code which is an online editor you can use with...
Bash: ^^}: bad substitution – upgrade your Bash version (macOS)
By HeyMo0sh
This blog post is about a situation where you are capitalising an argument in...
Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour”
By HeyMo0sh
This blog post relates to where you might be doing scale operations of your...
Forums
Error in bcp query out
I've been playing around wiht bcp out the data into csv file but been...
Multi subnet failover cluster
My goal is to have an FCI across 2 nodes with shared storage (node...
Power Query or SQL Server? Which, when and why
Comments posted to this topic are about the item Power Query or SQL Server?...
Ask SSC