GET Manager

 DECLARE

@ID VARCHAR(50) = ID ,

@Name varchar(500) = NULL,

@Title VARCHAR(20) = NULL

BEGIN

WAY:

SELECT   @Name = X1.SuperiorName, @Title = (select JobLvlGrpName 

FROM TBL_HRIS where empid = X1.SuperiorId)

   FROM TBL_HRIS X1

WHERE EmpId = @ID

SET @ID = (SELECT SuperiorId FROM TBL_HRIS

WHERE EmpId = @ID)

IF (@Title <> 'Manager') GOTO WAY;

select @Name EMPID, @Title TITLE

END