USP_DATALIST_COMMUNICATIONLETTER_NOSEQUENCE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN | |
| @CHANNELCODE | tinyint | IN |
Definition
Copy
create procedure dbo.USP_DATALIST_COMMUNICATIONLETTER_NOSEQUENCE
(
@SEGMENTATIONID uniqueidentifier,
@CHANNELCODE tinyint = null
)
as
set nocount on;
select
SEGMENTATIONID,
COMMUNICATIONLETTERID as ID,
NAME,
CHANNEL,
MAILCONTENTDEFINED,
EMAILCONTENTDEFINED,
MOVEUP_ENABLED,
MOVEDOWN_ENABLED,
REMOVE_ENABLED
from dbo.UFN_DATALIST_COMMUNICATIONLETTERS(@SEGMENTATIONID, @CHANNELCODE);