I would like to create one procedure for a variety of possibilities. If one parameter is passed do a select statement with one set of criteria. If a different parameter is passed perform the select statment with a different set of criteria. I have tried this:

If @param1 = x and @param2 = y
select statement1
else
if @param1 = y and @param2 = x
select statement2
else
select statement3

When I execute the procedure the last select statment is always performed. What am I missing here? Or is there a better way of doing something like this?

Thanks in advance
Kelly