USP_DATALIST_PARTICIPANTTITLE

CREATE procedure dbo.USP_DATALIST_PARTICIPANTTITLE(
  @ID uniqueidentifier,
  @EVENTID uniqueidentifier
)
as
    set nocount on;

  DECLARE @TEAMID uniqueidentifier

    IF EXISTS (SELECT TOP 1 R.ID FROM REGISTRANT R LEFT JOIN TEAMFUNDRAISINGTEAMCAPTAIN TFTC ON TFTC.CONSTITUENTID = R.CONSTITUENTID WHERE TFTC.TEAMFUNDRAISINGTEAMID=@ID AND R.EVENTID = @EVENTID)    
    BEGIN    
        SET @TEAMID=(SELECT TOP 1 R.ID FROM REGISTRANT R LEFT JOIN TEAMFUNDRAISINGTEAMCAPTAIN TFTC ON TFTC.CONSTITUENTID = R.CONSTITUENTID WHERE TFTC.TEAMFUNDRAISINGTEAMID=@ID AND R.EVENTID = @EVENTID)
    END    


  IF @TEAMID IS NOT NULL
  BEGIN
      SELECT        
      TE.TYPECODE,
      TFT.NAME AS TEAMNAME,
      dbo.UFN_REGISTRANT_GETNAME(R.ID) AS FULLNAME              
      FROM        REGISTRANT R 
      LEFT JOIN    TEAMFUNDRAISER TFR ON R.CONSTITUENTID = TFR.CONSTITUENTID
      LEFT JOIN    TEAMFUNDRAISINGTEAMMEMBER TFTM ON TFR.ID = TFTM.TEAMFUNDRAISERID
      LEFT JOIN    TEAMFUNDRAISINGTEAM TFT ON TFTM.TEAMFUNDRAISINGTEAMID = TFT.ID
      INNER JOIN    TEAMEXTENSION TE ON TFTM.TEAMFUNDRAISINGTEAMID = TE.TEAMFUNDRAISINGTEAMID AND TE.EVENTID = @EVENTID
      WHERE        R.ID= @TEAMID    AND R.EVENTID = @EVENTID
  END

  IF @TEAMID IS NULL
  BEGIN
    SELECT        
      0,
      '' AS TEAMNAME,
      C.NAME AS FULLNAME                  
      FROM        REGISTRANT R 
    LEFT JOIN CONSTITUENT C ON R.CONSTITUENTID = C.ID
      WHERE        R.ID= @ID    AND R.EVENTID = @EVENTID
  END