View All Development Resources

I made a gist for generating SQL Server Date Table

Well I made my very first 'Gist' on Github today, it's pretty neat and a much better way of storing snippets than Pastebin or a text file or something since it's versioned - win!

Anyway, this little SQL Snippet will put a lot of data into a Date table such as the day name, quarter, day of year, day of week, week number etc which can be useful for reporting. This data is everything that's already available via functions within SQL Server, but the table can be used for caching this data for faster retrieval if you rely on it for a lot of things.

Check it out and let me know what you think either on the comments here or @ GitHub :)