USP_DATALIST_TEAM_EXTENSION

CREATE procedure dbo.USP_DATALIST_TEAM_EXTENSION
(
        @TEAMFUNDRAISINGTEAMID uniqueidentifier = null,
      @TEAMCONSTITUENTID  uniqueidentifier = null
)
as
    set nocount on;

    select 
        TE.[ID],
        TE.[TEAMFUNDRAISINGTEAMID],
        TE.[EVENTID],
        TE.[PARTICIPANTGOAL],
        TE.[TEAMMEMBERGOAL],
        TE.[VOLUNTEERGOAL],
        TE.[COMMUNICATIONGOAL],
        TE.[OTHERGOAL],
        TE.[PCTTEAMMEMBERRETENSION],
        TE.[TEAMRECRUITMENTGOAL],
        TE.[PCTTEAMSRETENSION],
        T.[GOAL] as FUNDRAISINGGOAL,
        T.[NAME],
        TE.[TYPE],
        TE.[HOUSEHOLDID],
        TE.[TARGETFUNDRAISINGGOAL],
        TE.[DONORRETENTIONGOAL],
        TE.[TEAMCONSTITUENTID],
    TE.[STATUSCODE]
    from 
        dbo.TEAMEXTENSION TE (NOLOCK)
    INNER JOIN dbo.TEAMFUNDRAISINGTEAM T (NOLOCK)
    ON TE.TEAMFUNDRAISINGTEAMID = T.ID
    WHERE TE.TEAMFUNDRAISINGTEAMID = ISNULL(@TEAMFUNDRAISINGTEAMID,TE.TEAMFUNDRAISINGTEAMID)
  AND TE.TEAMCONSTITUENTID = ISNULL(@TEAMCONSTITUENTID,TE.TEAMCONSTITUENTID)