USP_REPORT_EFFORTEXCLUSIONS_PARAMETERS

create procedure dbo.[USP_REPORT_EFFORTEXCLUSIONS_PARAMETERS]
(
  @SEGMENTCALCULATEPROCESSSTATUSID uniqueidentifier
)
as
  set nocount on;

  declare @NAME nvarchar(100);
  declare @PROCESSDATE datetime;

  if exists (select top 1 1 from dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS] where [ID] = @SEGMENTCALCULATEPROCESSSTATUSID)
    select
      @NAME = [MKTSEGMENTATION].[NAME],
      @PROCESSDATE = [BUSINESSPROCESSSTATUS].[ENDEDON]
    from dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS]
    inner join dbo.[BUSINESSPROCESSSTATUS] on [BUSINESSPROCESSSTATUS].[ID] = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS].[ID]
    inner join dbo.[MKTSEGMENTATIONSEGMENTCALCULATEPROCESS] on [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[ID] = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS].[PARAMETERSETID]
    inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONSEGMENTCALCULATEPROCESS].[SEGMENTATIONID]
    where [MKTSEGMENTATIONSEGMENTCALCULATEPROCESSSTATUS].[ID] = @SEGMENTCALCULATEPROCESSSTATUSID;
  else
    select
      @NAME = [MKTSEGMENTATION].[NAME],
      @PROCESSDATE = [BUSINESSPROCESSSTATUS].[ENDEDON]
    from dbo.[MKTUPDATEMAILINGCOUNTSPROCESSSTATUS]
    inner join dbo.[BUSINESSPROCESSSTATUS] on [BUSINESSPROCESSSTATUS].[ID] = [MKTUPDATEMAILINGCOUNTSPROCESSSTATUS].[ID]
    inner join dbo.[MKTUPDATEMAILINGCOUNTSPROCESS] on [MKTUPDATEMAILINGCOUNTSPROCESS].[ID] = [MKTUPDATEMAILINGCOUNTSPROCESSSTATUS].[PARAMETERSETID]
    inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTUPDATEMAILINGCOUNTSPROCESS].[SEGMENTATIONID]
    where [MKTUPDATEMAILINGCOUNTSPROCESSSTATUS].[ID] = @SEGMENTCALCULATEPROCESSSTATUSID;

  select
    @NAME as [NAME],
    @PROCESSDATE as [PROCESSDATE];

  return 0;