spLoadRecord_FundraiserSolicitorEmail

Parameters

Parameter Parameter Type Mode Description
@PKID int IN

Definition

Copy

            CREATE   PROCEDURE [dbo].[spLoadRecord_FundraiserSolicitorEmail]
            (            
                @PKID int 
            )
            AS

            SELECT     
                [ID], 
                [FundraiserSolicitorsID], 
                [Type], 
                [Subject], 
                [Message], 
                [Closing], 
                [EmailJobID],
                [CreateDate],
                [dbo].[fnFundRaiserTotalDonationAmountBySolicitorEmailID](ID) [Raised]
            FROM FundraiserSolicitorEmail WHERE ID = @PKID