UFN_TEAMFUNDRAISINGTEAM_GETCAPTAINS

Returns all captains for a given team fundraising team.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TEAMFUNDRAISINGTEAMID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_TEAMFUNDRAISINGTEAM_GETCAPTAINS
            (
                @TEAMFUNDRAISINGTEAMID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    ID,
                    CONSTITUENTID
                from
                    dbo.TEAMFUNDRAISINGTEAMCAPTAIN
                where
                    TEAMFUNDRAISINGTEAMID = @TEAMFUNDRAISINGTEAMID
            )