Control flow in T-SQL SP using IF..ELSE IF - are there other ways? - Stack Overflow

I need to branch my T-SQL stored procedure (MS SQL 2008) control flow to a number of directions: CREATE PROCEDURE [fooBar] @inputParam INT AS BEGIN IF @inputParam = 1 BEGIN ... END ELSE IF @inputParam = 3 BEGIN ... END ELSE IF @ ...

stackoverflow.com