USP_DATAFORMTEMPLATE_ADD_MKTCOMMUNICATIONEFFORTSEED

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_MKTCOMMUNICATIONEFFORTSEED
(
  @ID uniqueidentifier = null output,
  @SEGMENTATIONID uniqueidentifier,
  @SEEDID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null
)
as

  set nocount on;

  if @ID is null
    set @ID = newid();

  if @CHANGEAGENTID is null  
    exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

  declare @CURRENTDATE datetime = getdate();

  begin try
  -- handle inserting the data
    insert into dbo.[MKTSEGMENTATIONSEED]
      ([ID], [SEEDID], [SEGMENTATIONID], [ADDEDBYID], [CHANGEDBYID], [DATEADDED], [DATECHANGED])
      values
      (@ID, @SEEDID, @SEGMENTATIONID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

  end try

  begin catch
      exec dbo.[USP_RAISE_ERROR];
      return 1;
  end catch

  return 0;