USP_DUPLICATESEARCH_MKTSEGMENTTIMESLOT

This provides the ability to search for duplicates of a time slot.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	ID
@CODE	nvarchar(10)	IN	Code
@MAXROWS	smallint	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



CREATE procedure dbo.[USP_DUPLICATESEARCH_MKTSEGMENTTIMESLOT]
(
  @ID uniqueidentifier = null,
  @CODE nvarchar(10) = null,
  @MAXROWS smallint = 100
)
as
  set nocount on;

  declare @TEMP table (
    [ID] uniqueidentifier,
    [NAME] nvarchar(100),
    [DESCRIPTION] nvarchar(255),
    [CODE] nvarchar(10),
    [INUSE] bit,
    [DUPLICATESELECTION] bit,
    [DUPLICATECODE] bit
  );

  --Find any duplicates for this public media...

  insert into @TEMP ([ID], [NAME], [DESCRIPTION], [CODE], [INUSE], [DUPLICATESELECTION], [DUPLICATECODE])
    exec dbo.[USP_MKTSEGMENT_FINDDUPLICATES]
      @ID = @ID,
      @SEGMENTTYPECODE = 7,
      @CODE = @CODE,
      @MAXROWS = @MAXROWS;

  --Get the public media type and add it to the results...

  select
    [TEMP].[ID],
    [TEMP].[NAME],
    [MKTSEGMENT].[SEGMENTTYPE],
    [TEMP].[DESCRIPTION],
    [TEMP].[CODE],
    [TEMP].[INUSE],
    [TEMP].[DUPLICATESELECTION],
    [TEMP].[DUPLICATECODE]
  from @TEMP as [TEMP]
  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [TEMP].[ID];

  return 0;