469,625 Members | 1,059 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

How to Go From a Database to A Calendar Format?


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.

Jul 23 '05 #1
1 1219
Create a Calendar table and then left-join it with your project


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

David Portas
SQL Server MVP

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by cg_news | last post: by
reply views Thread by Vincent Jones | last post: by
10 posts views Thread by vinu | last post: by
reply views Thread by GFro | last post: by
reply views Thread by abhishekbrave | last post: by
4 posts views Thread by abhishekbrave | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.