USP_REPORT_AMPROIMPORTBATCHCONTROL

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

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

                declare @SQL nvarchar(max);
                set @SQL = N'set nocount on;

                             select top 1
                                REPORTTABLE.ID,
                                [ORIGINAL].BATCHNUMBER as [ORIGINALBATCHNUMBER],
                                BATCH.BATCHNUMBER as [BATCHNUMBER],
                                (select USERNAME from dbo.APPUSER where APPUSER.ID = ORIGINAL.APPUSERID) as [OWNER],
                                ORIGINAL.STATUS,
                                CURRENCY.ISO4217,
                                CURRENCY.DECIMALDIGITS,
                                CURRENCY.CURRENCYSYMBOL,
                                CURRENCY.SYMBOLDISPLAYSETTINGCODE,
                                EVENT.NAME EVENTNAME
                             from
                                dbo.' + @TABLENAME + ' REPORTTABLE ' + '
                                inner join dbo.BATCHAMPROIMPORT on BATCHAMPROIMPORT.ID = REPORTTABLE.BATCHRECORDID
                                inner join dbo.EVENT on BATCHAMPROIMPORT.EVENTID = EVENT.ID
                                inner join dbo.CURRENCY on CURRENCY.ID = EVENT.BASECURRENCYID
                                inner join dbo.BATCH as [ORIGINAL] on [ORIGINAL].ID = @BATCHID
                                left join dbo.BATCH on BATCH.ORIGINATINGBATCHID = [ORIGINAL].ID;'

                exec sp_executesql @SQL, N'@BATCHID uniqueidentifier', @BATCHID = @BATCHID;