[thelist] To Store or Not to Store - Building dynamic queries

[Brian Cummiskey]

> For this phone book search engine site I'm working on, users will have
> the option to search by one or multiple search criteria.  Up to this
> point, I've been putting all queries into a stored procedure.  At this
> point, I'm unsure how to proceed.
>   

The easiest way is to pass in your parameters based on the 
checkboxes/form elements that are used to make a dynamic vairable query.
Note, this is server intensive but shouldn't be a big deal for the 
limited computation you need to do in your case.

CREATE proc PROCNAME
(
@param1 type(x)
@param2 type(x)
)

as
begin


declare @queryString varchar(8000)

if @param1 = 'xxxx'
    begin
       set @queryString = 'SELECT xxxxxx from yyyyyyy where fieldname = 
@param1'
    end

if @param2 = 'yyyy'
    begin
       set @queryString = 'SELECT zzzzzz from yyyyyyy  etc..... '
    end

exec(@queryString)

end