USP_DATALIST_MKTSOURCECODEPARTDEFINITIONVALIDVALUES

Displays a list of the valid source code part values associated with a source code and source code part definition.

Parameters

Parameter	Parameter Type	Mode
@SOURCECODEID	uniqueidentifier	IN
@PARTDEFINITIONID	uniqueidentifier	IN
@MAILINGTYPECODE	tinyint	IN

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTSOURCECODEPARTDEFINITIONVALIDVALUES]
(
  @SOURCECODEID uniqueidentifier = null,
  @PARTDEFINITIONID uniqueidentifier = null,
  @MAILINGTYPECODE tinyint = 0
)
as
  set nocount on;

  select 
    [MKTSOURCECODEPARTDEFINITIONVALUES].[ID],
    [MKTSOURCECODEPARTDEFINITION].[NAME],
    [MKTSOURCECODEPARTDEFINITIONVALUES].[DESCRIPTION],
    [MKTSOURCECODEPARTDEFINITIONVALUES].[FORMAT],
    [MKTSOURCECODEPARTDEFINITIONVALUES].[REGEX],
    [MKTSOURCECODEPARTDEFINITION].[ITEMTYPECODE],
    case when [MKTSOURCECODEPARTDEFINITION].[AUTOINCREMENTVALUE] = 1 then dbo.[UFN_MKTSOURCECODE_AUTOINCREMENTCODE]([MKTSOURCECODEPARTDEFINITIONVALUES].[ID], @MAILINGTYPECODE) else '' end as [NEXTCODE],
    [MKTSOURCECODEITEM].[ID],
    [MKTSOURCECODEPARTDEFINITIONVALUES].[LENGTH],
    [MKTSOURCECODEPARTDEFINITIONVALUES].[DELIM]
  from dbo.[MKTSOURCECODEITEM]
  inner join dbo.[MKTSOURCECODEVALIDPARTVALUES] on [MKTSOURCECODEVALIDPARTVALUES].[MKTSOURCECODEITEMID] = [MKTSOURCECODEITEM].[ID]
  inner join dbo.[MKTSOURCECODEPARTDEFINITIONVALUES] on [MKTSOURCECODEPARTDEFINITIONVALUES].[ID] = [MKTSOURCECODEVALIDPARTVALUES].[MKTSOURCECODEPARTDEFINITIONVALUESID]
  inner join dbo.[MKTSOURCECODEPARTDEFINITION] on [MKTSOURCECODEPARTDEFINITION].[ID] = [MKTSOURCECODEPARTDEFINITIONVALUES].[MKTSOURCECODEPARTDEFINITIONID]
  inner join dbo.[MKTSOURCECODE] on [MKTSOURCECODE].[ID] = [MKTSOURCECODEITEM].[SOURCECODEID]
  where (@PARTDEFINITIONID is null or [MKTSOURCECODEPARTDEFINITION].[ID] = @PARTDEFINITIONID)
    and (@SOURCECODEID is null or [MKTSOURCECODEITEM].[SOURCECODEID] = @SOURCECODEID);

  return 0;