UFN_MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT_GETBUSINESSUNITS

Returns all business units for a test segment.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MKTSEGMENTATIONTESTSEGMENTID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT_GETBUSINESSUNITS(@MKTSEGMENTATIONTESTSEGMENTID uniqueidentifier)
returns table
as return
            select
                ID,
        BUSINESSUNITCODEID,
        PERCENTVALUE
            from
                dbo.MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT
            where
                MKTSEGMENTATIONTESTSEGMENTID = @MKTSEGMENTATIONTESTSEGMENTID;