USP_REPORT_RATINGSBATCHEXCEPTIONREPORT

            create procedure dbo.USP_REPORT_RATINGSBATCHEXCEPTIONREPORT(@BATCHID uniqueidentifier) with execute as owner
            as
                set nocount on;

                declare @SQLTOEXEC nvarchar(200);
                set @SQLTOEXEC = N'
                    set nocount on;
                    select 
                        ID, IMPORTID, CONSTITUENTNAME, REASON
                    from
                        dbo.' + dbo.UFN_BATCH_GETREPORTTABLENAME(@BATCHID, 1);
                exec sp_executesql @SQLTOEXEC;