the query is actually very complex involving several loops and a few conditional clauses and I am hoping that by sticking it all into a stored procedure it will be precompiled by MSSQL and therefore more efficient.
On 12/06/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > James Smith wrote: > > > > SELECT Title, ProductID > > FROM aTable > > WHERE Stock > 0 > > <cfif len(trim(queryParams.productgroupid)) GT 0> > > AND ProductGroupID = #val(productgroupid)# > > </cfif> > > > > I wish to move this query into MSSQL server for performance reasons > > Which performance reasons? Why do you expect an improvement of the > performance from moving the condition to the DB? > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280812 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4