UFN_MKTCOMMUNICATIONTEMPLATEDEFAULTSEED_GETITEMLIST
Return
Return Type |
---|
table |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@COMMUNICATIONTEMPLATEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_MKTCOMMUNICATIONTEMPLATEDEFAULTSEED_GETITEMLIST]
(
@COMMUNICATIONTEMPLATEID uniqueidentifier
)
returns table
as
return
(
select
[MKTCOMMUNICATIONTEMPLATEDEFAULTSEED].[ID],
[MKTCOMMUNICATIONTEMPLATEDEFAULTSEED].[SEEDID],
[MKTCOMMUNICATIONTEMPLATEDEFAULTSEED].[LOCKED]
from dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULTSEED]
where
[COMMUNICATIONTEMPLATEID] = @COMMUNICATIONTEMPLATEID
)