UFN_MKTCOMMUNICATIONTEMPLATEDEFAULTASKLADDEROVERRIDE_GETITEMLIST

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@COMMUNICATIONTEMPLATEID uniqueidentifier IN

Definition

Copy


create function dbo.[UFN_MKTCOMMUNICATIONTEMPLATEDEFAULTASKLADDEROVERRIDE_GETITEMLIST](@COMMUNICATIONTEMPLATEID uniqueidentifier)
returns table
as
return 
(
  select 
    [ID],
    [IDSETREGISTERID],
    [ASKLADDERID],
    [SEQUENCE]
  from dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULTASKLADDEROVERRIDE]
  where [COMMUNICATIONTEMPLATEID] = @COMMUNICATIONTEMPLATEID
)