Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
-- ORIGINAL SELECT sob.id , MAX(jnl.jnlID) AS jnlID FROM sysobjects sob LEFT JOIN MyJournalTbl jnl ON jnl.object_ID = sob.id WHERE sob.name = 'MyTableName' AND sob.xtype IN ('U','V') GROUP BY sob.id ;
-- TESTING SELECT sob.id , jnl.jnlID FROM sysobjects sob OUTER APPLY ( SELECT TOP (1) jnlID FROM MyJournalTbl WHERE object_ID = sob.id ORDER BY jnlID DESC ) jnl WHERE sob.name = 'MyTableName' AND sob.xtype IN ('U','V') ;
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!