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
)