USP_REPORT_AMPROIMPORTBATCHCONTROL_AUCTIONPURCHASE

            CREATE procedure dbo.USP_REPORT_AMPROIMPORTBATCHCONTROL_AUCTIONPURCHASE
            (
                @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.REVENUETRANSACTIONAMOUNT,' +
                                ' REPORTTABLE.REVENUEPAYMENTMETHOD,' +
                                ' REPORTTABLE.CONSTITUENTNAME,' +
                                ' REPORTTABLE.ISO4217,' +
                                ' REPORTTABLE.DECIMALDIGITS,' +
                                ' REPORTTABLE.CURRENCYSYMBOL,' +
                                ' REPORTTABLE.SYMBOLDISPLAYSETTINGCODE,' +
                                ' count(BATCHAMPROIMPORTPURCHASEDETAIL.ID) PURCHASECOUNT,' +
                                ' TRANSACTIONTYPE.PURCHASEDETAIL_TRANSACTIONTYPE,' +
                                ' dbo.UDA_BUILDLIST(BATCHAMPROIMPORTMESSAGE.MESSAGE) MESSAGES' +
                             ' from' +
                                ' dbo.' + @TABLENAME + ' REPORTTABLE' +
                                ' inner join dbo.BATCHAMPROIMPORT on BATCHAMPROIMPORT.ID = REPORTTABLE.BATCHRECORDID' +
                                ' inner join dbo.BATCHAMPROIMPORTPURCHASE on BATCHAMPROIMPORTPURCHASE.ID = BATCHAMPROIMPORT.ID' +
                                ' inner join dbo.BATCHAMPROIMPORTPURCHASEDETAIL on BATCHAMPROIMPORTPURCHASEDETAIL.PURCHASEDETAIL_PURCHASEID = BATCHAMPROIMPORTPURCHASE.ID' +
                                ' left join dbo.BATCHAMPROIMPORTMESSAGE on BATCHAMPROIMPORTMESSAGE.AMPROIMPORTID = BATCHAMPROIMPORT.ID' +
                                ' cross apply(' +
                                            ' select top 1' +
                                                ' PURCHASEDETAIL.PURCHASEDETAIL_TRANSACTIONTYPE ' +
                                            ' from ' +
                                                ' dbo.BATCHAMPROIMPORTPURCHASEDETAIL PURCHASEDETAIL' +
                                            ' where ' +
                                                ' PURCHASEDETAIL.PURCHASEDETAIL_PURCHASEID = BATCHAMPROIMPORTPURCHASE.ID' +
                                ' ) TRANSACTIONTYPE' +
                            ' where' +
                                ' BATCHAMPROIMPORT.RECORDTYPECODE = 5' +
                            ' group by' +
                                ' REPORTTABLE.ID,' +
                                ' REPORTTABLE.REVENUETRANSACTIONAMOUNT,' +
                                ' REPORTTABLE.REVENUEPAYMENTMETHOD,' +
                                ' REPORTTABLE.CONSTITUENTNAME,' +
                                ' REPORTTABLE.ISO4217,' +
                                ' REPORTTABLE.DECIMALDIGITS,' +
                                ' REPORTTABLE.CURRENCYSYMBOL,' +
                                ' REPORTTABLE.SYMBOLDISPLAYSETTINGCODE,' +
                                ' TRANSACTIONTYPE.PURCHASEDETAIL_TRANSACTIONTYPE,' +
                                ' BATCHAMPROIMPORT.SEQUENCE' +
                        ' order by BATCHAMPROIMPORT.SEQUENCE;'

                exec sp_executesql @SQL;
            end