USP_DATALIST_REGISTRANTEAM

CREATE procedure dbo.USP_DATALIST_REGISTRANTEAM(@REGISTRANTID uniqueidentifier)with execute as caller
as
    set nocount on;

    Select R.ID,
            TM.TEAMFUNDRAISINGTEAMID,
            T.NAME,
            TT.TYPECODE
  From dbo.REGISTRANT R
         INNER JOIN dbo.TEAMFUNDRAISER TF 
             ON R.CONSTITUENTID = TF.CONSTITUENTID
         INNER JOIN dbo.TEAMFUNDRAISINGTEAMMEMBER TM
             ON TF.ID = TM.TEAMFUNDRAISERID
           INNER JOIN dbo.TEAMFUNDRAISINGTEAM T
               ON TM.TEAMFUNDRAISINGTEAMID = T.ID
         INNER JOIN dbo.EVENT E
            ON E.APPEALID = TF.APPEALID AND R.EVENTID = E.ID
         INNER JOIN dbo.TEAMEXTENSION TT
            ON T.ID = TT.TeamFundraisingTeamID
    WHERE R.ID = @REGISTRANTID