UFN_MKTSOURCECODE_GETITEMLIST
Returns a table of all of the source code items that have been assigned to the given source code layout
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SOURCECODEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MKTSOURCECODE_GETITEMLIST
(
@SOURCECODEID uniqueidentifier
)
/*
Returns a table of all of the source code items that have been assigned to the given source code layout
*/
returns table
as
return
(
select M.[ID], M.[ITEMTYPECODE], M.[NAME], M.[FORMAT], M.[SAMPLE], dbo.UFN_MKTSOURCECODE_GETPOSITION(M.[ID]) [POSITION], M.[NOTES], M.[DELIM], M.[LENGTH], M.[REGEX], M.[SEQUENCE]
from dbo.MKTSOURCECODEITEM M
where M.SOURCECODEID = @SOURCECODEID
)