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