Hi Folks,
I have a stored procedure that has 5 arguments. Any combination of these arguments could be passed to the SP for use in the WHERE clause.
Here's my question, is it possible to default each argument to a generic "select all" value, so the I only need one query with all the arguments in the WHERE clause, or do I have to write IF / Else IF tree to see if the argument has been passed or not (each one with its own select statement)?
cheers,
Brian Q