Create a Time Dimension in SQL Server
Here is a great link on how to create a time dimension for a relational data warehouse in SQL Server. It's great that I won't have to worry about this again!
https://sqljunkies.com/WebLog/enigma/archive/2004/02/04/940.aspx