spEventGuestReport

        CREATE PROCEDURE [dbo].[spEventGuestReport]
            (@FundraiserId int)
        AS
            select isnull(frt.Name, 'Independent') As Team, dbo.fnFundraiserTeamRegistrant(frs.id) As Registrant, 
            dbo.fnFundraiserIsCaptain(frs.TeamID, frs.ID, frs.RootFundraiserID) As Captain, cu.FirstName + ' ' + cu.LastName As Guest, isnull(et.XMLObjectData, et1.XMLObjectData) As XMLObjectData
            from 
            fundraiserSolicitors frs left join dbo.FundRaiserEventRegistrations fer on fer.SolicitorID = frs.ID
            left join dbo.EventTransactions et on fer.EventTransactionsID = et.EventTransactionsID
            left join FundraiserEventRegistrations fer1 on frs.RecruiterID = fer1.SolicitorID
            left join EventTransactions et1 on fer1.EventTransactionsID = et1.EventTransactionsID
            left join dbo.FundraiserTeams frt on frs.TeamID = frt.ID
            left join dbo.ClientUsers cu on frs.ClientUsersID = cu.ID
            where frs.RootFundraiserID = @FundraiserId --and cu.Active = 1
            order by Team, Captain desc, Registrant asc, Guest asc