USP_MKTSEGMENTATIONACTIVATEKPI_DELETEKPI

CREATE procedure dbo.USP_MKTSEGMENTATIONACTIVATEKPI_DELETEKPI
(
  @CHANGEAGENTID uniqueidentifier = null,
  @KPIINSTANCEID uniqueidentifier
)
as
begin

  set nocount on;

  declare @MKTSEGMENTATIONACTIVATEKPIID uniqueidentifier;

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

  begin try
    select
      @MKTSEGMENTATIONACTIVATEKPIID = [MKTSEGMENTATIONACTIVATEKPI].[ID]
    from
      dbo.[MKTSEGMENTATIONACTIVATEKPI]
      inner join dbo.[KPIINSTANCE] on [KPIINSTANCE].[CONTEXTRECORDID] = cast([MKTSEGMENTATIONACTIVATEKPI].[SEGMENTATIONID] as nvarchar(100)) and [KPIINSTANCE].[KPICATALOGID] = [MKTSEGMENTATIONACTIVATEKPI].[KPICATALOGID]
    where
      [KPIINSTANCE].[ID] = @KPIINSTANCEID;

    if @MKTSEGMENTATIONACTIVATEKPIID is not null
      exec dbo.[USP_MKTSEGMENTATIONACTIVATEKPI_DELETEBYID_WITHCHANGEAGENTID] @MKTSEGMENTATIONACTIVATEKPIID, @CHANGEAGENTID;

  end try

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

  return 0;
end