USP_REPORT_AUCTIONITEMEXCEPTIONREPORT

Returns the data necessary for the Auction Item Batch control report.

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHID	uniqueidentifier	IN

Definition

Copy



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

            declare @TABLENAME nvarchar(128);
            set nocount on;

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

            declare @SQL nvarchar(max);

            set @SQL = N'set nocount on;
                select
                    ORIGINALBATCHNUMBER,
                    BATCHNUMBER,
                    OWNER,
                    ID,
                    DONOR,
                    DONORLOOKUPID,
                    NAME,
                    VALUE,
                    REASON,
                    ISOCURRENCYCODE,
                    CURRENCYSYMBOL,
                    SYMBOLDISPLAYSETTINGCODE,
                    DECIMALDIGITS
                from dbo.' + @TABLENAME;

            exec sp_executesql @SQL;