By dynamic I mean that the SQL statement is built on the fly. You can do this with stored procedures but its cumbersome and takes more da tabase resources(memory) to accomplish.
HTH Clint ---------- Original Message ---------------------------------- from: Amanda Stern <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Sun, 24 Feb 2002 15:12:02 -0800 (PST) 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 > > ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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
