> 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]
