spFundRaiserThankContactDonations

CREATE   PROCEDURE dbo.spFundRaiserThankContactDonations(@SolicitorContactID int)

AS
    BEGIN

        UPDATE FundRaiserDonations
        SET [ThankedDate] = getutcdate() 

        WHERE
        ID IN
        (
        SELECT don.ID 
        FROM dbo.FundraiserSolicitorContactAction actions
        inner join FundRaiserDonations don on don.id = actions.FundRaiserDonationsID
        WHERE 
        actions.FundraiserSolicitorContactID = @SolicitorContactID
        )

    END