spDelete_FundRaiserSolicitorGifts

Parameters

Parameter	Parameter Type	Mode	Description
@SolicitorID	int	IN
@CurrentUsersID	int	IN

Definition

Copy



                    CREATE procedure [dbo].[spDelete_FundRaiserSolicitorGifts]
            (
            @SolicitorID int,
            @CurrentUsersID    int
            )
            as
            update dbo.donationtransactions set isdeleted=1
            from dbo.donationtransactions dt where 
            exists 
            (select null
                from dbo.fundraiserdonations frd
                where frd.donationtransactionsid = dt.donationtransactionsid
                and frd.solicitorid = @SolicitorID
                and dt.processed_date is not null
                and frd.giftbackofficeid is not null
            )