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