USP_REPORT_MERCHANDISEINVENTORYBATCHEXCEPTION

create procedure dbo.USP_REPORT_MERCHANDISEINVENTORYBATCHEXCEPTION
(
    @BATCHID uniqueidentifier
)
with execute as caller
as
    declare @TABLENAME nvarchar(128);

    set nocount on;

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

    declare @SQLTOEXEC nvarchar(512);

    set @SQLTOEXEC = N'set nocount on;
        select 
            ORIGINALBATCHNUMBER, 
            BATCHNUMBER, 
            OWNER, 
            ID,            
            ITEMDETAILS,
            ACTIONTYPE,
            QUANTITY,
            COST,
            ADJUSTMENTREASON,
            REASON
        from dbo.[' + @TABLENAME + ']';

    exec sp_executesql @SQLTOEXEC;