In this post I’ll explain how to create a simple date dimension to use it in your data warehouses and your BI solutions. So, this article is for you if you need a fast and easy way to make a simple date dimension that supports the most commonly used date elements like
· Integer date key
· Different date formats
· Quarter
· Month names
· Week numbers
· Day of the week
· Day of the year
· Is day end of month
· Not available (N/A) row
Due to the fact that there are lots of fellows that are still using SQL Server 2008 and earlier, I put the codes that support SQL Server 2008 as well as SQL Server 2012. But, I’ve commented the 2008 lines.
Continue reading “Creating a Simple Date Dimension Using Recursive Common Table Expressions (CTE)”