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;