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