spFundRaiserTeamListingReport

Parameters

Parameter Parameter Type Mode Description
@FundraiserId int IN

Definition

Copy


                CREATE PROCEDURE [dbo].[spFundRaiserTeamListingReport]
                    (@FundraiserId int)
                AS
                    select
                    FundraiserId,
                    Fundraiser, 
                    TeamId, 
                    TeamName,
                    AmountRaised,
                    Goal,
                    TeamSize
                    from dbo.vwFundRaiserTeamSummaries vw    
                    where vw.FundraiserId = @FundraiserId
                    order by vw.TeamName