USP_MKTSEGMENTATIONACTIVATE_GETFINDERNUMBERFIELDS
Retrieves the maximum finder number in use by the marketing effort as well as the fixed width of the finder definition. This function is used to validate that the generated finder does not exceed the fixed width definition.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_MKTSEGMENTATIONACTIVATE_GETFINDERNUMBERFIELDS
(
@SEGMENTATIONID uniqueidentifier
)
as
set nocount on;
select
isnull(max([MAX]),0),
dbo.[UFN_MKTFINDERNUMBER_GETFIXEDWIDTH](0, @SEGMENTATIONID)
from dbo.[MKTSEGMENTATIONFINDERNUMBER]
where [SEGMENTATIONID] = @SEGMENTATIONID;
return 0;