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

formal syntax is really more like..

IF
BEGIN
...
END
ELSE
IF
BEGIN
...
END

but I think SQL doesn't mind shortening to ELSE IF..