Date Dimensions in T-SQL using CTE
T-SQL Script for Time Dimension Table Data: Populates Data between two dates for Reporting Solutions.
2011-07-04 (first published: 2010-06-14)
3,756 reads
time dimension
Blogs
SQL Server Query Tuning and Optimization by Benjamin Nevarez
I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin...
Slides from SQL Saturday Los Angeles 2022
By Steve Jones
If you attended my talk at SQL Saturday Los Angeles 2022, then you can...
Creating a HEAD utility for Windows 10
By Steve Jones
One of the things I did often in my first career job was create...
Forums
How to use PowerShell to set secure SA passwords for bulk servers
Comments posted to this topic are about the item How to use PowerShell to...
Substitute 0 and 1 values in 1 column
Hello everyone, Hi have this column named Sex and it only has value 0...
Finding difference in two databases/tables
I have compared two tables with the same data in two different databases(aslo the...
Ask SSC