USP_SIMPLEDATALIST_MKTSEGMENTATIONKPICURRENCY

Returns a list of the currencies available for a marketing KPI.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SEGMENTATIONID	uniqueidentifier	IN
@CURRENCYID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.[USP_SIMPLEDATALIST_MKTSEGMENTATIONKPICURRENCY]
(
  @CURRENTAPPUSERID uniqueidentifier,
  @SEGMENTATIONID uniqueidentifier = null,
  @CURRENCYID uniqueidentifier = null
)
as
  set nocount on;

  declare @VALUES table ([VALUE] uniqueidentifier, [LABEL] nvarchar(110), [FORCESEQUENCE] tinyint);

  if @SEGMENTATIONID is not null
    insert into @VALUES 
    select [BASECURRENCYID], 'Base', 1
    from dbo.[MKTSEGMENTATION]
    where [ID] = @SEGMENTATIONID;

  insert into @VALUES values (dbo.[UFN_CURRENCY_GETORGANIZATIONCURRENCY](), 'Organization', 2);

  if @SEGMENTATIONID is null
    insert into @VALUES values (dbo.[UFN_APPUSER_GETBASECURRENCY](@CURRENTAPPUSERID), 'My Base', 3);

  if @CURRENCYID is not null and not exists (select top 1 1 from @VALUES where [VALUE] = @CURRENCYID)
    insert into @VALUES values (@CURRENCYID, dbo.[UFN_CURRENCY_GETDESCRIPTION](@CURRENCYID), 0);

  select [VALUE], [LABEL]
  from @VALUES
  order by [FORCESEQUENCE], [LABEL];

  return 0;