USP_MKTSEGMENTATION_EFFORTEXCLUSIONSPROCESS_SAVE

CREATE procedure dbo.[USP_MKTSEGMENTATION_EFFORTEXCLUSIONSPROCESS_SAVE]
(
  @SEGMENTATIONID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null
)
as
  set nocount on;

  declare @CURRENTDATE datetime;

  begin try
    if not exists(select 1 from dbo.[MKTSEGMENTATIONEXCLUSIONSPROCESS] where [SEGMENTATIONID] = @SEGMENTATIONID)
      begin
        if @CHANGEAGENTID is null  
          exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

        set @CURRENTDATE = getdate();

        insert into dbo.[MKTSEGMENTATIONEXCLUSIONSPROCESS] (
          [ID],
          [SEGMENTATIONID],
          [ADDEDBYID],
          [CHANGEDBYID],
          [DATEADDED],
          [DATECHANGED]
        ) values (
          newid(),
          @SEGMENTATIONID,
          @CHANGEAGENTID,
          @CHANGEAGENTID,
          @CURRENTDATE,
          @CURRENTDATE
        );
      end
  end try

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

  return 0;