>Does no one see how inefficient it is to write 20 variations of the same query just to support multiple parameters?
Mike,
T-SQL is not strong typing language, it is more like VFP. If you not call the SP with all parameters the parameters is defined with the type you want but has value NULL. Of course you could set a default value for every parameter.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.