USP_MEMBERSHIPRENEWALEFFORTPROCESS_GETSEGMENTS

Gets segments in a membership renewal effort.

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPMAILINGPROCESSID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_MEMBERSHIPRENEWALEFFORTPROCESS_GETSEGMENTS
(
    @MEMBERSHIPMAILINGPROCESSID uniqueidentifier
)
as
begin

    select MKTSEGMENTREFRESHPROCESS.ID as SEGMENTREFRESHPROCESSID,
        MKTSEGMENT.ID as SEGMENTID,
        MKTMEMBERSHIPMAILINGTEMPLATE.ID as MEMBERSHIPMAILINGTEMPLATEID
    from dbo.MKTSEGMENTREFRESHPROCESS
        inner join dbo.MKTSEGMENT on MKTSEGMENTREFRESHPROCESS.SEGMENTID = MKTSEGMENT.ID
        inner join dbo.MKTMEMBERSHIPMAILINGTEMPLATERULE on MKTSEGMENT.ID = MKTMEMBERSHIPMAILINGTEMPLATERULE.SEGMENTID 
        inner join dbo.MKTMEMBERSHIPMAILINGTEMPLATE on MKTMEMBERSHIPMAILINGTEMPLATERULE.MEMBERSHIPMAILINGTEMPLATEID = MKTMEMBERSHIPMAILINGTEMPLATE.ID 
        inner join dbo.MKTMEMBERSHIPMAILINGPROCESS on MKTMEMBERSHIPMAILINGTEMPLATE.ID = MKTMEMBERSHIPMAILINGPROCESS.MEMBERSHIPMAILINGTEMPLATEID 
    where MKTMEMBERSHIPMAILINGPROCESS.ID = @MEMBERSHIPMAILINGPROCESSID

end