USP_DATALIST_TEAMREGISTRANT

To get the Registrant that given Team belongs to.

Parameters

Parameter	Parameter Type	Mode	Description
@TEAMFUNDRAISINGTEAMID	uniqueidentifier	IN	TeamFundraisingTeamID

Definition

Copy



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

    Select R.ID
  From dbo.REGISTRANT R
         INNER JOIN dbo.TEAMFUNDRAISINGTEAMCAPTAIN TF 
             ON R.CONSTITUENTID = TF.CONSTITUENTID
    WHERE TF.TEAMFUNDRAISINGTEAMID = @TEAMFUNDRAISINGTEAMID