You'll have to excuse me on this one but when you say dynamic, do you mean that the report requires form variables to be passed to it from the user?
--- Clint Tredway <[EMAIL PROTECTED]> wrote: > I use stored procs and views to do my reports. I > find this be the best unle > ss my report is dynamic. > > HTH > Clint > > > ---------- Original Message > ---------------------------------- > from: Amanda Stern <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > date: Sun, 24 Feb 2002 14:41:10 -0800 (PST) > > Hello, > > The application I am working on has about 10 reports > that are being run every month. The queries for > these > reports are written in the CFML page using > <CFQUERY>. > I was wondering if it would be better(execution > timewise) to write a stored procedure on the MS SQL > side and calling it in the CFML page. The few > applications that I have seen have not used stored > procedures...does anyone out there use stored procs > for report writing...is this not common practice??? > > > Thanks! > > __________________________________________________ > Do You Yahoo!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
