USP_REPORT_INTERACTIONBATCHEXCEPTIONREPORT

                create procedure dbo.USP_REPORT_INTERACTIONBATCHEXCEPTIONREPORT
                (
                    @BATCHID uniqueidentifier
                ) 
                with execute as owner
                as
                    declare @TABLENAME nvarchar(128);

                    set nocount on;

                    select @TABLENAME = dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 1);

                    declare @SQLTOEXEC nvarchar(500);

                    set @SQLTOEXEC = N'set nocount on;
                        select 
                            ID, 
                            CONSTITUENTNAME, 
                            OWNERNAME, 
                            OBJECTIVE, 
                            STATUS, 
                            CONTACTMETHOD,
                            DATE,
                            REASON
                        from 
                            dbo.' + @TABLENAME;

                    exec sp_executesql @SQLTOEXEC;