USP_DATALIST_MKTALLMARKETINGPLANTASKS

Displays a list of the active marketing plan tasks for all plans.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	ID
@DUEDATE	nvarchar(8)	IN	Due date
@OWNER	nvarchar(100)	IN	Owner
@MARKETINGPLANTASKSTATUSCODE	tinyint	IN	Status

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTALLMARKETINGPLANTASKS]
(
  @ID uniqueidentifier=null,
  @DUEDATE nvarchar(8)=null,
  @OWNER nvarchar(100)=null,
  @MARKETINGPLANTASKSTATUSCODE tinyint = null
)
as
  set nocount on;

  select
    T.ID,
    T.DUEDATE,
    T.DATECOMPLETED,
    CASE T.MARKETINGPLANTASKSTATUSCODE
    WHEN 0 THEN 'Active'
    WHEN 1 THEN 'Completed'
    ELSE '' END,
    T.SUBJECT,
    T.OWNER,
    T.NOTES
  from
    dbo.[MKTMARKETINGPLANITEMTASK] T
  where
    ((T.MARKETINGPLANITEMID=@ID) or (@ID is null)) and
    ((T.DUEDATE=@DUEDATE) or (@DUEDATE is null)) and
    ((T.OWNER=@OWNER) or (@OWNER is null)) and
    ((T.MARKETINGPLANTASKSTATUSCODE=@MARKETINGPLANTASKSTATUSCODE) or (@MARKETINGPLANTASKSTATUSCODE is null))
  order by
    T.DUEDATE,
    T.SUBJECT;

  return 0;