Hello

My department has a SQL server database that is used to all facets of
production within our department. This includes key production job
steps, project names, numbers and descriptions.

The calendar is currently done manually as an Excel document. The user
recieves hard copies of the required information, then keys it into the
appropriate place on the Excel document.

We would like to pull information out of that database, and put it in a
monthly calendar format. For example, take a project name and the date
associated with that project, and put it on a calendar in the
appropriate date "square".

If you have information or experience with software that can be used to
accomplish this task, I would appreciate hearing your advice.

Thanks in advance.

Create a Calendar table and then left-join it with your project
schedule:

http://www.google.co.uk/groups?hl=en...oglegroups.com

The rest is just formatting that you can do in your reporting tool.

--
David Portas
SQL Server MVP
--