spFundRaiserParticipantReport

        create procedure [dbo].[spFundRaiserParticipantReport]
            (@FundraiserId int)
        AS
            select 
                RootFundraiserId, 
                FrsId, 
                FirstName, 
                LastName, 
                TeamName, 
                BackofficeSolicitorId, 
                UserId, 
                ParentId, 
                TeamId, 
                Goal, 
                AmountRaised, 
                RecruiterId, 
                Inactive, 
                IsDirty, 
                AthonUnits, 
                AthonLocked, 
                Personalization, 
                BackofficeTeamId
            from 
                vwFundraiserParticipants vw
            where vw.RootFundraiserId = @FundraiserId
            order by vw.TeamName, FirstName