USP_REPORT_AMPROIMPORTBATCHCONTROL_AUCTIONITEM

            CREATE procedure dbo.USP_REPORT_AMPROIMPORTBATCHCONTROL_AUCTIONITEM
            (
                @BATCHID uniqueidentifier
            )
            with execute as owner
            as
            begin
                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
                                REPORTTABLE.ID,
                                REPORTTABLE.AUCTIONITEMNAME,
                                REPORTTABLE.AUCTIONITEMDONORNAME,
                                case
                                    when BATCHAMPROIMPORTITEM.AUCTIONITEM_LINKID is null then 1
                                    else 0
                                end ISNEWAUCTIONITEM,
                                dbo.UDA_BUILDLIST(BATCHAMPROIMPORTMESSAGE.MESSAGE) MESSAGES
                             from
                                dbo.' + @TABLENAME + ' REPORTTABLE ' + '
                                inner join dbo.BATCHAMPROIMPORT on BATCHAMPROIMPORT.ID = REPORTTABLE.BATCHRECORDID
                                inner join dbo.BATCHAMPROIMPORTITEM on BATCHAMPROIMPORTITEM.ID = BATCHAMPROIMPORT.ID
                                left join dbo.BATCHAMPROIMPORTMESSAGE on BATCHAMPROIMPORTMESSAGE.AMPROIMPORTID = BATCHAMPROIMPORT.ID
                             where
                                BATCHAMPROIMPORT.RECORDTYPECODE = 4
                             group by
                                REPORTTABLE.ID,
                                REPORTTABLE.AUCTIONITEMNAME,
                                REPORTTABLE.AUCTIONITEMDONORNAME,
                                BATCHAMPROIMPORTITEM.AUCTIONITEM_LINKID,
                                BATCHAMPROIMPORT.SEQUENCE
                            order by BATCHAMPROIMPORT.SEQUENCE;'

                exec sp_executesql @SQL;
            end