USP_REPORT_MERCHANDISEINVENTORYBATCHCONTROL

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

    set nocount on;

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

    declare @SQLTOEXEC nvarchar(512);

    set @SQLTOEXEC = N'set nocount on;
        select 
            ID,
            ACTIONTYPECODE,
            ACTIONTYPE,
            ITEMDETAILS,
            ONHANDQUANTITY,
            QUANTITY,
            COST,
            AVERAGECOST,
            SALEPRICE,
            VENDOR,
            REASON,
            COMMENTS
        from dbo.[' + @TABLENAME + ']
        order by ITEMDETAILS';

    exec sp_executesql @SQLTOEXEC;