>>>Does no one see how inefficient it is to write 20 variations of the same query just to support multiple parameters? >> >>Where are you getting that from? I didn't see anyone recommending that. > >http://sqlserver2000.databases.aspfaq.com/can-i-have-optional-parameters-to-my-stored-procedures.html > >It looks like he's recommending having stored procedures GetAuthors1 - GetAuthors. Maybe that's just his way of showing execution plans?