UFN_FAF_TEAMCONSTITUENTID_BY_TEAMID

Get team constituent ID by TeamID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TEAMID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN

Definition

Copy



CREATE FUNCTION dbo.UFN_FAF_TEAMCONSTITUENTID_BY_TEAMID
(
 @TEAMID uniqueidentifier = NULL
,@EVENTID uniqueidentifier = NULL
)
RETURNS TABLE
AS
RETURN
(
    select  TFT.ID TEAMID
    ,TFT.NAME TEAMNAME
    ,TE.TYPE TEAMTYPE
    ,TE.TYPECODE TEAMTYPECODE
    ,C.ID TEAMCONSTITUENTID
    ,C.KEYNAME  TEAMCONSTITUENTNAME
    from TEAMFUNDRAISINGTEAM TFT
    INNER JOIN TEAMEXTENSION TE ON TE.TEAMFUNDRAISINGTEAMID=TFT.ID
    INNER JOIN EVENT EV ON EV.APPEALID=TFT.APPEALID 
    inner join CONSTITUENT C ON C.ID=TE.TEAMCONSTITUENTID 
    WHERE EV.ID=@EVENTID
    AND TFT.ID=@TEAMID
)