A Stock Price Correlation Matrix
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
2012-05-14
6,670 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
7,461 reads
Blogs
STRING_SPLIT Basics–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL...
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition
As we all know there is already a lot of information available about SQL...
Forums
Migrate the SSIS Catalog in Just a Few Clicks
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
SQL Server Kerberos authentication from a Linux clients
Hi All, I have a need to establish a SQL Server Kerberos authentication from...
Housekeeping of SQL Azure DB's
Hi all, I have a question for you, as some move into the cloud...
Ask SSC