-- 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') ;
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.