A Stock Price Correlation Matrix
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
2012-05-14
6,894 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
8,450 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
ASCII value of certain column is null
When ASCII(Column) is null, what does it represent? Is this some kind of special/control...
Need to output table data into multiple CSV files
Hello, I created the below script to output 999 rows from SQL Server table...
Changing Database page Verify on a Database in an AG
I have a database on SQL 2019 in an Availability Group (AG) and I...
Ask SSC