Tag Archives: T-SQL;SQL Tips;SQL Tricks;SQL Automation;Table Function

Normalizing time-series data using a table function in SQL

Recently I had to normalize quarterly, monthly, and ad-hoc reported metrics into daily rows in order to do correlative analysis. Below is the function that I came up with. The idea is to generate values that are in line with … Continue reading

Posted in SQL Server, SQL Tips and Techniques | Tagged | Leave a comment