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