Re: Simplifying db queries

On 3 Mar 2005 18:08:12 -0800, cruiserweight wrote:

>a google of "calendar table", "mysql calendar table" or "mysql calendar
>table for reporting" provides nothing obvious. can you suggest
>something more specific.

Hi cruiserweight,

The link below takes you to a web page explaining how to create and fill a calendar table on MS SQL Server 2000, and goes on to illustrate some typical ways to use this table. I don't know MySQL, so I can't tell how easy or hard it is to adapt the code.

http://www.aspfaq.com/show.asp?id=2519

Best, Hugo

-- 

(Remove _NO_ and _SPAM_ to get my e-mail address)