Select 'exec DataNotification @pSourceType=38, @pSourceKey=''' + CONVERT(VARCHAR(100),InventoryItemKey) + ''',@pBatchKey=''' + CONVERT(VARCHAR(100),NewID()) + ''', @pOperationType=0,@pUserKey=1'
from invinventoryitem WITH (NOLOCK)
join InvProduct on InvProduct.ProductKey=invinventoryitem.ProductKey
where InvProduct.Id='TEST002'
Comments