UFN_MKTMEMBERSHIPMAILINGTEMPLATESOURCECODEPART_GETITEMLIST
Returns a table of all of the source code items that have been assigned to the given membership renewal effort template.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MEMBERSHIPMAILINGTEMPLATEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTMEMBERSHIPMAILINGTEMPLATESOURCECODEPART_GETITEMLIST]
(
@MEMBERSHIPMAILINGTEMPLATEID uniqueidentifier
)
returns table
as
return
(
select
[PART].[ID],
[PART].[CODE],
[PART].[SOURCECODEITEMID],
[PART].[CHANNELCODE],
[PART].[PARTDEFINITIONVALUESID]
from dbo.[MKTSOURCECODEPART] as [PART]
where [MEMBERSHIPMAILINGTEMPLATEID] = @MEMBERSHIPMAILINGTEMPLATEID
);