UFN_DOWNLOAD_MKTSEGMENTATIONPACKAGE_DOCUMENT
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_DOWNLOAD_MKTSEGMENTATIONPACKAGE_DOCUMENT](@ID uniqueidentifier)
returns table
as return select [MKTPACKAGE].[DOCUMENTFILE] from dbo.[MKTPACKAGE] inner join dbo.[MKTSEGMENTATIONPACKAGE] on [MKTSEGMENTATIONPACKAGE].[PACKAGEID] = [MKTPACKAGE].[ID] where [MKTSEGMENTATIONPACKAGE].[ID] = @ID;