TSQL Challenge 61 - Generate an HTML calendar in TSQL

By Jacob Sebastian, 2011/07/25

This challenge is to generate an HTML calendar based on the data stored in a table.

http://beyondrelational.com/puzzles/tsql/61/english/generate-an-html-calendar-in-tsql.aspx

Total article views: 1727 | Views in the last 30 days: 5

ARTICLE

Calendar Tables

Learn how to avoid complex date calculations and increase performance using calendar tables in this ...

FORUM

4-4-5 Calendar Functions, Part 1

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.

SCRIPT

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-di...

FORUM

Holiday Calendar Generator

Hello all. I would like to create a calendar table within SQL Server, include holidays and populat...

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

TSQL Challenge 61 - Generate an HTML calendar in TSQL

Calendar Tables

Temporary Table

4-4-5 Calendar Functions, Part 1

Date Calendar

Holiday Calendar Generator

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: