USP_DATALIST_FAFTEAMMEMBER

          CREATE procedure dbo.USP_DATALIST_FAFTEAMMEMBER
           (
            @EVENTID uniqueidentifier, 
            @TEAMID uniqueidentifier = null,
            @TEAMCONSTITUENTID uniqueidentifier = null
           ) with execute as owner
           as
              set nocount on;

              select C.ID,
                     C.NAME,
                     T.ID as TEAMID,
                 T.NAME as TEAMNAME,
                 TE.TYPE as TEAMTYPE,
                 TE.STATUS as GROUPSTATUS,
         RE.ALLOWOTHERPARTICIPANTSCONTACTME
            from dbo.TEAMFUNDRAISINGTEAMMEMBER TM (NOLOCK)
            INNER JOIN dbo.TEAMFUNDRAISINGTEAM T (NOLOCK)
            ON T.ID = TM.TEAMFUNDRAISINGTEAMID
            INNER JOIN dbo.TEAMEXTENSION TE (NOLOCK)
            ON T.ID = TE.TEAMFUNDRAISINGTEAMID
            INNER JOIN dbo.TEAMFUNDRAISER TF (NOLOCK)
            ON TM.TEAMFUNDRAISERID = TF.ID
            INNER JOIN dbo.CONSTITUENT C (NOLOCK)
            ON C.ID = TF.CONSTITUENTID
            INNER JOIN dbo.REGISTRANT R (NOLOCK)
            on R.CONSTITUENTID = C.ID
            INNER JOIN dbo.REGISTRANTEXTENSION RE (NOLOCK)
            on RE.REGISTRANTID = R.ID
            where TE.EVENTID = @EVENTID
            AND TE.TEAMFUNDRAISINGTEAMID = ISNULL(@TEAMID,TE.TEAMFUNDRAISINGTEAMID)
            AND TE.TEAMCONSTITUENTID = ISNULL(@TEAMCONSTITUENTID,TE.TEAMCONSTITUENTID)