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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280806 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4