USP_REPORT_AUCTIONITEMBATCHCONTROLREPORT

            CREATE procedure dbo.USP_REPORT_AUCTIONITEMBATCHCONTROLREPORT
            (
                @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);

            declare @TRANSACTIONCURRENCYCOUNT int = 0;

            set @SQL = N'set nocount on;
                        select @TRANSACTIONCURRENCYCOUNT = count(distinct TRANSACTIONCURRENCYID)
                        from
                        dbo.' + @TABLENAME + ' as [DATA] 
                        inner join dbo.BATCH on BATCH.ID = @BATCHID
                        left join dbo.BATCHAUCTIONITEM on BATCHAUCTIONITEM.ID = [DATA].BATCHRECORDID'

            exec sp_executesql @SQL, N'@TRANSACTIONCURRENCYCOUNT int output, @BATCHID uniqueidentifier', 
                @TRANSACTIONCURRENCYCOUNT output, 
                @BATCHID;

            set @SQL = N'set nocount on;
                select
                    [DATA].ID,
                    BATCH.BATCHNUMBER,
                    BATCH.STATUS,
                    BATCH.EXCEPTIONBATCHNAME,
                    coalesce((select USERNAME from dbo.APPUSER where ID = BATCH.APPUSERID), '''') as [OWNER],
                    [DATA].ITEMNAME,
                    [DATA].AUCTIONITEMCATEGORY,
                    [DATA].AUCTIONITEMSUBCATEGORY,
                    [DATA].DONOR,
                    [DATA].DONORLOOKUPID,
                    [DATA].VALUE,
                    [DATA].AUCTION,
                    [DATA].DONATIONDATE,
                    [DATA].DESIGNATION,
                    [DATA].ISOCURRENCYCODE,
                    [DATA].CURRENCYSYMBOL,
                    [DATA].SYMBOLDISPLAYSETTINGCODE,
                    [DATA].DECIMALDIGITS,
                    @TRANSACTIONCURRENCYCOUNT as TRANSACTIONCURRENCYCOUNT
                from dbo.' + @TABLENAME + ' as [DATA] 
                inner join dbo.BATCH on BATCH.ID = @BATCHID
                left join dbo.BATCHAUCTIONITEM on BATCHAUCTIONITEM.ID = [DATA].BATCHRECORDID
                order by BATCHAUCTIONITEM.SEQUENCE';

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