USP_MKTSPONSORSHIPMAILINGTEMPLATEAPPEAL_GETFIELDS
Gets appeal information associated with an sponsorship effort template.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SPONSORSHIPMAILINGTEMPLATEID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.[USP_MKTSPONSORSHIPMAILINGTEMPLATEAPPEAL_GETFIELDS]
(
@SPONSORSHIPMAILINGTEMPLATEID uniqueidentifier
)
as
set nocount on;
declare @CURRENTDATE datetime;
set @CURRENTDATE = GetDate();
/* Get appeal information */
select
[RECORDSOURCEID],
[APPEALSYSTEMID],
[APPEALID],
[APPEALDESCRIPTION]
from
dbo.[MKTSPONSORSHIPMAILINGTEMPLATEAPPEAL]
where
[MKTSPONSORSHIPMAILINGTEMPLATEAPPEAL].[SPONSORSHIPMAILINGTEMPLATEID] = @SPONSORSHIPMAILINGTEMPLATEID;
return 0;