USP_MKTMEMBERSHIPMAILINGPROCESS_GETOPTIONS
Retrieves the options for a membership renewal effort template process parameter set.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.[USP_MKTMEMBERSHIPMAILINGPROCESS_GETOPTIONS]
(
@ID uniqueidentifier
)
as
set nocount on;
select
[MKTMEMBERSHIPMAILINGPROCESS].[MEMBERSHIPMAILINGTEMPLATEID],
[MKTMEMBERSHIPMAILINGTEMPLATE].[RUNACTIVATEANDEXPORT]
from dbo.[MKTMEMBERSHIPMAILINGPROCESS]
inner join dbo.[MKTMEMBERSHIPMAILINGTEMPLATE] on [MKTMEMBERSHIPMAILINGTEMPLATE].[ID] = [MKTMEMBERSHIPMAILINGPROCESS].[MEMBERSHIPMAILINGTEMPLATEID]
where [MKTMEMBERSHIPMAILINGPROCESS].[ID] = @ID;
return 0;