spGetFundraiserEmails

CREATE PROCEDURE dbo.spGetFundraiserEmails
    (            
        @FundraisersID int 
    )
    AS

    SELECT     
        [ID], 
        [FundraisersID], 
        [CreateDate], 
        [UpdateDate], 
        [Deleted],
        [Type], 
        [EmailTEmplateID],
        [DisplayName]
        FROM FundraiserEmail WHERE FundraisersID = @FundraisersID