spFundRaiserTopSummaries

Parameters

Parameter Parameter Type Mode Description
@FrIds nvarchar(4000) IN

Definition

Copy


            create PROCEDURE [dbo].[spFundRaiserTopSummaries]

                (@FrIds nvarchar(4000))

            AS

                select top 10 

                    vw.Id,

                    vw.Name,

                    vw.AmountRaised,

                    vw.Goal,

                    vw.DonationCount,

                    vw.Participants,

                    vw.Teams

                from 

                    vwFundraiserSummaries vw

                    inner join dbo.fnMakeIDsTableFromString(@FrIds, ',') ids

                    on vw.Id = ids.id

                order by 

                    vw.AmountRaised desc