GetTeamNameOrAbbreviation.sql

CREATE PROCEDURE GetTeamNameOrAbbreviation
    @team NVARCHAR(255),
    @slot INT
AS
BEGIN
    IF @slot = 0
    BEGIN
        -- Extract and return the part before the parentheses
        RETURN LEFT(@team, CHARINDEX(' (', @team) - 1)
    END
    ELSE IF @slot = 1
    BEGIN
        -- Extract and return the part inside the parentheses
        RETURN SUBSTRING(@team, CHARINDEX('(', @team) + 1, CHARINDEX(')', @team) - CHARINDEX('(', @team) - 1)
    END
    ELSE
    BEGIN
        -- Return an error message if slot is not 0 or 1
        RETURN 'Invalid slot value. Please provide 0 or 1.'
    END
END


-- Usage Example
-- @team = 'Chief Financial Office (CFO)'
-- @slot = 1
-- EXEC GetTeamNameOrAbbreviation @team=@team @slot=@slot