Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
-- 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.