USP_REPORT_EFFORTEXCLUSIONS_SUMMARY

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

  declare @TABLENAME nvarchar(128);
  declare @SQL nvarchar(max);

  --Get the table output table name to use for the report...

  select
    @TABLENAME = [BUSINESSPROCESSOUTPUT].[TABLENAME]
  from dbo.[BUSINESSPROCESSSTATUS]
  inner join dbo.[BUSINESSPROCESSOUTPUT] on [BUSINESSPROCESSOUTPUT].[BUSINESSPROCESSSTATUSID] = [BUSINESSPROCESSSTATUS].[ID]
  where [BUSINESSPROCESSSTATUS].[ID] = @SEGMENTCALCULATEPROCESSSTATUSID
  and [BUSINESSPROCESSOUTPUT].[TABLEKEY] = 'EFFORTEXCLUSIONS';

  --Get the exclusion summary info...

  set @SQL = 'select' + char(13) +
             '  [EXCLUSIONTYPE],' + char(13) +
             '  [EXCLUSIONREASON],' + char(13) +
             '  count(1) as [RECORDCOUNT]' + char(13) +
             'from dbo.[' + @TABLENAME + ']' + char(13) +
             'group by [EXCLUSIONTYPE], [EXCLUSIONREASON]' + char(13) +
             'order by [EXCLUSIONTYPE], [EXCLUSIONREASON]';
  exec (@SQL);

  return 0;