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

[Casey Crookston]

Looks like this works - or at least does not error out when created.
Thanks for your help!


CREATE proc DELETEME
(
@param1 varchar(4000),
@param2 varchar(4000)
)

as
begin

declare @whereString nvarchar(4000)
declare @queryString nvarchar(4000)

if @param1 > ''
    begin
       set @whereString = 'xxxxxx LIKE @param1'
    end

if @param2 > ''
    begin
       set @whereString = @whereString  + 'AND zzzzzz LIKE @param2 '
    end

set @queryString = 'SELECT * FROM table WHERE ' + @whereString

exec(@queryString)

end