USP_SIMPLEDATALIST_MKTPLANITEMSFORDATE

Returns a list of plan items for a given date

Parameters

Parameter	Parameter Type	Mode	Description
@DATE	UDT_FUZZYDATE	IN	Date
@ID	uniqueidentifier	IN	ID

Definition

Copy



CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTPLANITEMSFORDATE]
(
  @DATE as dbo.[UDT_FUZZYDATE] = '00000000',
  @ID as uniqueidentifier = null
)
as
  set nocount on;

  select
    [ID] as [VALUE],
    [NAME] as [LABEL]
  from dbo.[MKTMARKETINGPLANITEM]
  with (nolock)
  where (([STARTDATE] <= @DATE or ([STARTDATE] = '00000000' and [ENDDATE] >= @DATE)) and
         ([ENDDATE] >= @DATE or ([ENDDATE] = '00000000' and [STARTDATE] <= @DATE)))
     or [ID] = @ID;

  return 0;