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