USP_BBNC_GETTEAMFUNDRAISERS

            create procedure dbo.USP_BBNC_GETTEAMFUNDRAISERS
            (
                @APPEALMAPID int
            )
            as
                set nocount on;

                select
                    [TEAMFUNDRAISERMAP].[ID] as [BBNCID],
                    [TEAMFUNDRAISER].[GOAL],
                    [CONSTITUENT].[SEQUENCEID] as [CONSTITUENTBBNCID],
                    coalesce
                    (
                        (
                            select top 1
                                [TEAMMAP].[ID]
                            from
                                dbo.TEAMFUNDRAISINGTEAMMEMBER
                                inner join dbo.BBNCTEAMFUNDRAISINGTEAMIDMAP as [TEAMMAP] on [TEAMFUNDRAISINGTEAMMEMBER].[TEAMFUNDRAISINGTEAMID] = [TEAMMAP].[TEAMFUNDRAISINGTEAMID]
                            where
                                [TEAMFUNDRAISINGTEAMMEMBER].[TEAMFUNDRAISERID] = [TEAMFUNDRAISER].[ID]
                            order by
                                [TEAMFUNDRAISINGTEAMMEMBER].[DATECHANGED] desc
                        ),
                        0
                    ) as [TEAMBBNCID]
                from
                    dbo.BBNCAPPEALIDMAP as [APPEALMAP]
                    inner join dbo.TEAMFUNDRAISER on [APPEALMAP].[APPEALID] = [TEAMFUNDRAISER].[APPEALID]
                    inner join dbo.BBNCTEAMFUNDRAISERIDMAP as [TEAMFUNDRAISERMAP] on [TEAMFUNDRAISER].[ID] = [TEAMFUNDRAISERMAP].[TEAMFUNDRAISERID]
                    inner join dbo.CONSTITUENT on [TEAMFUNDRAISER].[CONSTITUENTID] = [CONSTITUENT].[ID]
                where
                    [APPEALMAP].[ID] = @APPEALMAPID
                order by
                    [CONSTITUENT].[NAME];