UFN_MKTSEGMENTATIONASKLADDEROVERRIDE_GETITEMLIST

Returns a table of all of the ask ladder overrides associated with a given marketing effort.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@SEGMENTATIONID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_MKTSEGMENTATIONASKLADDEROVERRIDE_GETITEMLIST(@SEGMENTATIONID uniqueidentifier)
/*
Returns a table of all of the ask ladder overrides associated with a given mailing
*/
returns table
as
return 
(
  select 
    A.[ID] 
    ,A.[ASKLADDERID] 
    ,A.[IDSETREGISTERID]
    ,A.[SEQUENCE]
  from dbo.[MKTSEGMENTATIONASKLADDEROVERRIDE] A
  where A.[SEGMENTATIONID] = @SEGMENTATIONID
)