USP_DATAFORMTEMPLATE_PLANITEMTASK_VIEW

The load procedure used by the view dataform template "Plan Item Task View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@MARKETINGPLANITEM	nvarchar(max)	INOUT	Marketing plan item
@SUBJECT	nvarchar(100)	INOUT	Subject
@NOTES	nvarchar(max)	INOUT	Notes
@DUEDATE	datetime	INOUT	Due date
@DATECOMPLETED	datetime	INOUT	Date completed
@TASKSTATUS	nvarchar(9)	INOUT	Task status

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PLANITEMTASK_VIEW]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @MARKETINGPLANITEM nvarchar(max) = null output,
  @SUBJECT nvarchar(100) = null output,
  @NOTES nvarchar(max) = null output,
  @DUEDATE datetime = null output,
  @DATECOMPLETED datetime = null output,
  @TASKSTATUS nvarchar(9) = null output
)
as
  set nocount on;

  select
    @DATALOADED = 1,
    @MARKETINGPLANITEM = dbo.[UFN_MKTMARKETINGPLANITEM_PATH]([MARKETINGPLANITEMID], 1),
    @SUBJECT = [SUBJECT],
    @NOTES = [NOTES],
    @DUEDATE = dbo.[UFN_DATE_EARLIESTFROMFUZZYDATE]([DUEDATE]),
    @DATECOMPLETED = [DATECOMPLETED],
    @TASKSTATUS = [MARKETINGPLANTASKSTATUS]
  from dbo.[MKTMARKETINGPLANITEMTASK]
  where [ID] = @ID;

  return 0;