UFN_MKTSEGMENTATIONSEGMENTLIST_GETVENDORMANAGEDQUANTITY
Returns the number of records in a marketing effort vendor managed list segment.
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTID | uniqueidentifier | IN | |
| @TESTSEGMENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSEGMENTATIONSEGMENTLIST_GETVENDORMANAGEDQUANTITY]
(
@SEGMENTID uniqueidentifier,
@TESTSEGMENTID uniqueidentifier
)
returns integer
as
begin
declare @TOTALOFFERS integer = dbo.[UFN_MKTSEGMENTATIONSEGMENTLIST_GETQUANTITY](@SEGMENTID, 3);
-- factored logic out of here and into common function so it can be used elsewhere
declare @OFFERS integer = dbo.[UFN_MKTSEGMENTATIONSEGMENT_GETOFFERCOUNT](@SEGMENTID, @TESTSEGMENTID, @TOTALOFFERS);
return @OFFERS;
end