UFN_SEGMENT_GETSELECTIONS

Returns a table of all selections associated with a segment.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_SEGMENT_GETSELECTIONS
            (
                @SEGMENTID uniqueidentifier
            )
            returns table
            as
                return
                (
                    select
                        MKTSEGMENTSELECTION.ID [ID],
                        MKTSEGMENTSELECTION.SELECTIONID [SELECTIONID]
                    from
                        dbo.MKTSEGMENTSELECTION
                    where
                        MKTSEGMENTSELECTION.SEGMENTID = @SEGMENTID
                );