USP_REPORT_DECEASEDFINDERBATCHEXCEPTION

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

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

            declare @SQLTOEXEC nvarchar(1000);
            set @SQLTOEXEC = N'set nocount on;
                select 
                    ID,
                    NAME,
                    SUBMITTEDADDRESS,
                    DECEASEDDATE,
                    DECEASEDCONFIRMATION,
                    DECEASEDSOURCE,
                    REASON
                from 
                    dbo.' + @TABLENAME

            exec sp_executesql @SQLTOEXEC;