Most xml sql variable substitution related news are at:

sqlmusings.com
– belle’s sql musings
Demystifying T-SQL Subqueries–Part II 19 Nov 2012 | 11:53 am
In the last post (Demystifying T-SQL Subqueries – Part I) we looked at how to use scalar subqueries. Let’s continue our subquery adventure. As with Part I, the following T-SQL query samples are using ...
Demystifying T-SQL Subqueries–Part I 13 Nov 2012 | 10:39 am
When I teach SQL Server Development/T-SQL courses, subqueries is usually one of those topics that students find confusing. Usually it’s a head scratcher, although there are some who just get it. So le...