You need to use the BEGIN/END construct like this:

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

>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