UFN_MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE_GETITEMLIST

Returns a table of all of the ask ladder overrides associated with a given marketing acknowledgement template.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ACKNOWLEDGEMENTMAILINGTEMPLATEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.[UFN_MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE_GETITEMLIST]
(
  @ACKNOWLEDGEMENTMAILINGTEMPLATEID uniqueidentifier
)
returns table
as
return (select 
          [ID],
          [ASKLADDERID],
          [IDSETREGISTERID],
          [SEQUENCE]
        from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE]
        where [ACKNOWLEDGEMENTMAILINGTEMPLATEID] = @ACKNOWLEDGEMENTMAILINGTEMPLATEID);