sorry, not an ounce of Oracle knowledge... good luck with it though -----Original Message----- From: Aidan Whitehall [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 12:41 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Quick query question...
> Could you do this by building a dates table and joining to that? I remember > in a previous company having such a set-up when we regularly used a dates > table made up of columns such as DDMMYYYY, MMDDYYYY, Period, Month etc etc.. > > I appreciate am lot of this has been superseded by dateformat and the > like, but I think it would give you to result you require? Better than > looping through each date and running a separate query.... Yeah, that's a thought -- thanks. BTW, do you know if there's a way of generating in-memory tables in Oracle? Was wondering if it would be quicker to execute a quick DDL statement with the right number of days to generate a table against which the main query is then joined. -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] DISCLAIMER: This e-mail is confidential and may also be legally privileged. If you are not the intended recipient, use of the information contained in this e-mail (including disclosure, copying or distribution) is prohibited and may be unlawful. Please inform the sender and delete the message immediately from your system. This e-mail is attributed to the sender and may not necessarily reflect the views of the Patsystems Group and no member of the Patsystems Group accepts any liability for any action taken in reliance on the contents of this e-mail (other than where it has a legal or regulatory obligation to do so) or for the consequences of any computer viruses which may have been transmitted by this e-mail. The Patsystems Group comprises Patsystems plc and its subsidiary group of companies. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
