UFN_MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT_GETBUSINESSUNITDESCRIPTION
Returns the business units and percent credit for each effort.
Return
| Return Type |
|---|
| nvarchar(max) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONTESTSEGMENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT_GETBUSINESSUNITDESCRIPTION]
(
@SEGMENTATIONTESTSEGMENTID uniqueidentifier
)
returns nvarchar(max)
with execute as caller
as begin
declare @TESTSEGMENTATION_BUSINESSUNITS nvarchar(max);
select
@TESTSEGMENTATION_BUSINESSUNITS = dbo.[UDA_BUILDLIST]([BUSINESSUNITCODE].[DESCRIPTION] + ' - ' + convert(nvarchar(10), cast([MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT].[PERCENTVALUE] as money), 0) + '%')
from dbo.[BUSINESSUNITCODE]
inner join dbo.[MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT] on [MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT].[BUSINESSUNITCODEID] = [BUSINESSUNITCODE].[ID]
where [MKTSEGMENTATIONTESTSEGMENTBUSINESSUNIT].[MKTSEGMENTATIONTESTSEGMENTID] = @SEGMENTATIONTESTSEGMENTID;
return @TESTSEGMENTATION_BUSINESSUNITS;
end