Microsoft has a fix for the "Slow Execution of a Query that Contains a Correlated Subquery" in one of its latest KB artcles. Just thought you might to check it out. http://support.microsoft.com/default.aspx?scid=kb;en-us;823514 Nathan H.O. Moderator SQL-Server-Performance.com
Seems the semi-colons got stripped out of your hyperlink let me try... http://support.microsoft.com/default.aspx?scid=kb;en-us;823514
Useful to know, thanks vbkenya. It would have been nice if MS had clarified more about the symptoms.<br />I use correlated queries of this nature quite a lot, and whilst they seem to perform reasonably, the article does not go into any detail about its definition of 'slow'. Consequently, Ive no idea whether I would benefit from the fix or not. Needless to say Ill err on the side of caution and let it pass <img src='/community/emoticons/emotion-6.gif' alt='' /><br />
Neither have I been able to get any 'true' usefulness from the 'Fix'. Somebody else with a different set of queries might shed some light on the issue. Maybe the example code in the fix is the actual specific problem....... Nathan H.O. Moderator SQL-Server-Performance.com