(Baya Pavliashvili) The AUTO mode of the FOR XML extension lets you use subqueries, which can be a useful trick for certain XML formatting needs. Subqueries can be used for a variety of reasons, one of them being limiting the returned result set.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help