Kelly,

It would be easier to answer you question if you post actual code of the sproc. Anyway, the third statement is executed because both IF's conditions evaluate to false.

>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?