http://www2.sqlblog.com/blogs/adam_machanic/archive/tags/_2300_tsql2sday/xml/default.aspxTags: #tsql2sday, xmlenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/adam_machanic/archive/2010/01/12/t-sql-tuesday-002-is-it-xml-or-not.aspxTue, 12 Jan 2010 21:19:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:20965Adam Machanic8http://www2.sqlblog.com/blogs/adam_machanic/comments/20965.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=20965The query optimizer is a finicky thing , and sometimes it doesn't understand exactly what you're trying to do until you give it a bit more information. The situation I'm going to describe in this post is one such case. By providing the optimizer with...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2010/01/12/t-sql-tuesday-002-is-it-xml-or-not.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=20965" width="1" height="1">puzzlexmlT-SQL Tuesday#tsql2sday