USP_MKTRECORDSOURCE_FINDINLIST

Returns a list id for the list that contains a specific record id.

Parameters

Parameter	Parameter Type	Mode
@RECORDID	uniqueidentifier	IN
@LISTID	uniqueidentifier	INOUT
@RECORDSOURCEID	uniqueidentifier	INOUT

Definition

Copy



create procedure dbo.[USP_MKTRECORDSOURCE_FINDINLIST]
(
  @RECORDID uniqueidentifier,
  @LISTID uniqueidentifier output,
  @RECORDSOURCEID uniqueidentifier output
)
as
  set nocount on;

  declare @SEGMENTLISTID uniqueidentifier;

  select
    @SEGMENTLISTID = [SEGMENTLISTID]
  from dbo.[MKTSEGMENTLISTDATA]
  where [ID] = @RECORDID;

  if @SEGMENTLISTID is not null
    select
      @LISTID = [MKTLIST].[ID],
      @RECORDSOURCEID = [MKTLIST].[RECORDSOURCEID]
    from dbo.[MKTSEGMENTLIST]
    inner join dbo.[MKTLIST] on [MKTLIST].[ID] = [MKTSEGMENTLIST].[LISTID]
    where [MKTSEGMENTLIST].[ID] = @SEGMENTLISTID;
  else
    begin
      set @LISTID = null;
      set @RECORDSOURCEID = null;
    end

  return 0;