[RESOLVED] SPROC - Conditional Branching

[sevenhalo]

You can try:

DECLARE @Type INT
SET @Type = 2

SELECT CASE @Type
	WHEN 1 THEN 'Number 1'
	WHEN 2 THEN 'Number 2'
	WHEN 3 THEN 'Number 3'
	WHEN 4 THEN 'Number 4'
	WHEN 5 THEN 'Number 5'
	ELSE 'Something Else'
END