Re: Dynamic SQL in STored Procedures

From: "Andy H" <lokidb@hotmail.com> > >I have a stored procedure that has a number of parameters passed to it. >Some > or all of these parameters are used in the WHERE clause of the SELECT >statement on a FOREACH loop. > > >I was wondering if it was possible to build the SQL statement dynamically >in > SPL to improve the performance when SELECTing from the database ie the >WHERE clause would only use those parameters that have a value specified >for them. If you're using 9.x you can download Paul Brown's dynamic SPL datablade from http://www.iiug.org. Otherwise, no. _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com