From: Peter Brawley
Date: July 17 2008 6:25pm
Subject: Re: Calendar creation
List-Archive: http://lists.mysql.com/mysql/213699
Message-Id: <487F8EAF.5020102@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Craig,

>Is there any simple way to create a calendar table?

See "Make a calendar table" at 
http://www.artfulsoftware.com/infotree/queries.php.

PB

Weston, Craig (OFT) wrote:
> Hi there,
>
> Is there any simple way to create a calendar table? For example I want
> to create a reference calendar containing all the dates of several years
> so I can accurately represent even days where I have no data in my data
> set.  Any ideas?
>
>  
>
> Thanks,
>
> Craig
> --------------------------------------------------------
> This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system.
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com 
> Version: 8.0.138 / Virus Database: 270.5.0/1558 - Release Date: 7/17/2008 9:56 AM
>
>
>