I tried conditional WHERE clauses not too long ago and found a few things:

1) Instead of dynamic where conditions in a sproc, another option is to allow the DAL to...