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