USP_DATALIST_MKTSEGMENTATIONFINDERNUMBERGAPS
Displays a list of available finder number ranges.
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
@ID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.[USP_DATALIST_MKTSEGMENTATIONFINDERNUMBERGAPS]
(
@CURRENTAPPUSERID uniqueidentifier = null,
@ID uniqueidentifier = null
)
as
set nocount on;
select [MIN], [MAX]
from dbo.[UFN_MKTSEGMENTATIONFINDERNUMBER_GAPS](@ID)
order by [MIN] desc;
return 0;