spLoadRecord_FundraiserSolicitorContact
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@PKID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spLoadRecord_FundraiserSolicitorContact]
(
@PKID 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 ID = @PKID