USP_REPORT_WPBATCHSCREENINGPROCESSEXCEPTIONREPORT

            create procedure dbo.USP_REPORT_WPBATCHSCREENINGPROCESSEXCEPTIONREPORT(@ID nvarchar(36))
            with execute as owner
            as
                set nocount on;        
                declare @TABLENAME nvarchar(255);
                declare @SQL nvarchar(4000);

                select
                    @TABLENAME = BUSINESSPROCESSOUTPUT.TABLENAME 
                from
                    dbo.BUSINESSPROCESSSTATUS
                inner join
                    dbo.BUSINESSPROCESSOUTPUT
                on
                    BUSINESSPROCESSSTATUS.ID = BUSINESSPROCESSOUTPUT.BUSINESSPROCESSSTATUSID
                where
                    BUSINESSPROCESSSTATUS.ID = @ID and
                    BUSINESSPROCESSOUTPUT.TABLEKEY = 'EXCEPTION';


                if @TABLENAME is null or OBJECT_ID(@TABLENAME) is null
                        raiserror('Business process exception table could not be found.  The process might not have completed successfully. ',13,1)

                begin try
                    set @SQL = 'select
                                    RESEARCHGROUPID,
                                    RESEARCHGROUP.NAME,
                                    RESEARCHGROUP.DESCRIPTION,
                                    EX.EXCEPTION,
                                    SUBSTRING(EX.JOBID,18,9) as JOBID
                                from dbo.' +
                                    @TABLENAME + '    as EX
                                inner join dbo.RESEARCHGROUP on EX.RESEARCHGROUPID = RESEARCHGROUP.ID
                            order by
                                RESEARCHGROUP.NAME,
                                RESEARCHGROUP.DESCRIPTION;'                    


                    exec sp_executesql @SQL;
                end try

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