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);