USP_SIMPLEDATALIST_COMMUNITYMEMBERTEAMFUNDRAISERAPPEAL

List of appeals in which a Blackbaud Internet Solutions user is participating.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent

Definition

Copy



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

                    select
                        [APPEAL].[ID] [VALUE],
                        [APPEAL].[NAME] [LABEL]
                    from
                        dbo.TEAMFUNDRAISER
                        inner join dbo.APPEAL on [TEAMFUNDRAISER].[APPEALID] = [APPEAL].[ID]
                    where
                        [TEAMFUNDRAISER].[CONSTITUENTID] = @CONSTITUENTID
                    order by
                        [APPEAL].[NAME];