>
It looks like he's recommending having stored procedures GetAuthors1 - GetAuthors. Maybe that's just his way of showing execution plans? >
>Mike, I'm not sure where you're getting that.
>
>If you're reading the same page that I am...
>
>
http://sqlserver2000.databases.aspfaq.com/can-i-have-optional-parameters-to-my-stored-procedures.html>
>...you may want to go back and read the page again. With optional parameters, a developer may also need to use something like COALESCE or ISNULL: the author wrote 4 stored procs for different combinations of them to determine which method(s) are most efficient.
>
>Anyone promoting 20 different stored procs for 20 different combos of variable parameters should be flamed.
Sorry about that. I have recently seen actual production code with different combos from a current programming college professor.