gistfile1.sql

 IF @TypeId = 0
	BEGIN
		SELECT SuggestionId, [Message], [Type] 
		FROM so_Suggestion main
		INNER JOIN so_Suggestion_Model joined ON main.SuggestionId = joined.SuggestionId
		WHERE main.[Type] = @TypeId
	END
ELSE IF @TypeId = 1 
	BEGIN
		SELECT SuggestionId, [Message], [Type] 
		FROM so_Suggestion main
		INNER JOIN so_Suggestion_Version joined ON main.SuggestionId = joined.SuggestionId
		WHERE main.[Type] = @TypeId
	END