spGetFundraiserSolicitorEmail

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

            SELECT     
                [ID], 
                [FundraiserSolicitorsID], 
                [Type], 
                [Subject], 
                [Message], 
                [Closing], 
                [EmailJobID],
                [CreateDate],
                [dbo].[fnFundRaiserTotalDonationAmountBySolicitorEmailID](ID) [Raised]


            FROM FundraiserSolicitorEmail WHERE FundraiserSolicitorsID = @FundraiserSolicitorsID