SELECT
  B1.BranchID,
  B1.PositionID,
  B1.LevelID,
  COALESCE(B1.LeaderPositionID, 0) AS LeaderPositionID,
  B2.Description AS LeaderDescription,
  B1.Description,
  B1.ConsultantID,
  U1.FullName AS Consultant
FROM
  taBranchStructure AS B1
    LEFT JOIN taUsers AS U1 ON (U1.UserID = B1.ConsultantID)
    LEFT JOIN taBranchStructure AS B2 ON (B2.PositionID = B1.LeaderPositionID)
WHERE
  (B1.BranchID = @nBranchID)
ORDER BY
  B1.LevelID,
  B1.Description,
  U1.FullName
