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

It is the same as:

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

But is formatted that way it is hard to read, isn't it?