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
)