UFN_MKTSEGMENT_GETGROUPS
Returns a table containing the groups to which a segment belongs.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MKTSEGMENT_GETGROUPS
(
@SEGMENTID uniqueidentifier
)
returns table
as
return
(
select
[MKTGROUPSEGMENTS].[ID],
[MKTGROUPSEGMENTS].[SEGMENTGROUPID],
[MKTSEGMENTGROUP].[NAME],
[MKTGROUPSEGMENTS].[SEQUENCE]
from dbo.[MKTSEGMENTGROUP]
inner join dbo.[MKTGROUPSEGMENTS] on [MKTSEGMENTGROUP].[ID] = [MKTGROUPSEGMENTS].[SEGMENTGROUPID]
where [MKTGROUPSEGMENTS].[SEGMENTID] = @SEGMENTID
)