>What's wrong with one SP. You always can use structure like this:
>

>IF @Something1
>   BEGIN
>   -- Select 1
>   END
>ELSE IF @Something2
>   BEGIN
>   -- Select 2
>   END
>ELSE IF @Something3
>   BEGIN
>   -- Select 3
>   END
>

SQL Server Help doesn't list the syntax you suggested.