spGetFundraiserSolicitorContacts

            CREATE  PROCEDURE [dbo].[spGetFundraiserSolicitorContacts]
            (            
                @FundraiserSolicitorsID int 
            )
            AS

            SELECT     
                [ID], 
                [AddressbookContactsID], 
                [FundraiserSolicitorsID], 
                [CreateDate], 
                [UpdateDate], 
                [Deleted],
                [EmailAddress], 
                [Appeal], 
                [Thanks], 
                [Unsolicited],
                [dbo].[fnFundRaiserTotalDonationAmountBySolicitorContactID]([ID]) Donated,
                [dbo].[fnFundRaiserSolicitorContactTotalEmailsSent]([ID]) EmailsSent,
                [dbo].[fnFundRaiserForwardedTotalDonationAmount]([ID]) ForwardedDonated
            FROM FundraiserSolicitorContact WHERE FundraiserSolicitorsID = @FundraiserSolicitorsID