USP_SIMPLEDATALIST_APPEALMAILINGS
Displays a list of mailings associated with an appeal.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @APPEALID | uniqueidentifier | IN | Appeal |
Definition
Copy
CREATE procedure dbo.[USP_SIMPLEDATALIST_APPEALMAILINGS]
(
@APPEALID uniqueidentifier
)
as
set nocount on;
select
[MKTSEGMENTATION].[ID] as [VALUE],
[MKTSEGMENTATION].[NAME] as [LABEL]
from dbo.[MKTSEGMENTATIONACTIVATE]
inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATIONACTIVATE].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
where [MKTSEGMENTATIONACTIVATE].[APPEALSYSTEMID] = cast(@APPEALID as nvarchar(36))
and [MKTSEGMENTATION].[ACTIVE] = 1
order by [MKTSEGMENTATION].[NAME];
return 0;