UFN_BBNC_GETCONSTITIDFROMTEAMFUNDRAISERMAPID

Returns the constituent ID for the specified team fundraiser integer mapping ID for NetCommunity.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN

Definition

Copy



            create function dbo.UFN_BBNC_GETCONSTITIDFROMTEAMFUNDRAISERMAPID
            (
                @ID int
            )
            returns uniqueidentifier
            as
            begin
                return
                (
                    select top (1)
                        [TEAMFUNDRAISER].[CONSTITUENTID]
                    from
                        dbo.BBNCTEAMFUNDRAISERIDMAP
                        inner join dbo.TEAMFUNDRAISER on [BBNCTEAMFUNDRAISERIDMAP].[TEAMFUNDRAISERID] = [TEAMFUNDRAISER].[ID]
                    where
                        [BBNCTEAMFUNDRAISERIDMAP].[ID] = @ID
                )
            end