USP_DATALIST_TEAMCAPTAIN

Get the list of team captains.

Parameters

Parameter	Parameter Type	Mode	Description
@TEAMFUNDRAISINGTEAMID	uniqueidentifier	IN	Team
@CONSTITUENTID	uniqueidentifier	IN	Constituent

Definition

Copy



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

                SELECT ID,
                       TEAMFUNDRAISINGTEAMID,
                       CONSTITUENTID
                FROM dbo.TEAMFUNDRAISINGTEAMCAPTAIN WITH (NOLOCK)
                where TEAMFUNDRAISINGTEAMID = ISNULL(@TEAMFUNDRAISINGTEAMID,TEAMFUNDRAISINGTEAMID)
              AND CONSTITUENTID = ISNULL(@CONSTITUENTID,CONSTITUENTID)