UFN_MEMBERSHIPRENEWALEFFORTMAILINGPROCESS_GETQUANTITY

Returns the quantity of the records processed by membership renewal effort.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID	uniqueidentifier	IN
@MEMBERSHIPMAILINGPROCESSSTATUSID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_MEMBERSHIPRENEWALEFFORTMAILINGPROCESS_GETQUANTITY (
  @MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID uniqueidentifier,
  @MEMBERSHIPMAILINGPROCESSSTATUSID uniqueidentifier
)
returns int
with execute as caller
as begin

    declare @QUANTITY int;
    set @QUANTITY = 0;
    select @QUANTITY = [SEGMENTATIONEXPORTPROCESSSTATUS].[NUMBERPROCESSED]
    from  dbo.[BUSINESSPROCESSSTATUS] [SEGMENTATIONEXPORTPROCESSSTATUS]
        inner join dbo.[MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS]
        on [SEGMENTATIONEXPORTPROCESSSTATUS].[ID] = [MKTMEMBERSHIPRENEWALEFFORTMAILINGPROCESS].[SEGMENTATIONEXPORTPROCESSSTATUSID]
    where [MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID] = @MEMBERSHIPRENEWALEFFORTPROCESSSTATUSID
        and [MEMBERSHIPMAILINGPROCESSSTATUSID] = @MEMBERSHIPMAILINGPROCESSSTATUSID;

    return @QUANTITY;

end