Use nested FOR XML queries in ASP.NET [!INCLUDE SQL Server Azure SQL Database] In this example, an ASP.NET application returns XML to a browser by executing a stored procedure in SQL Server. The ...

MS SQL Server: Nested Object Queries Introduction You can use the object (one-to-one) or array (one-to-many) relationships defined in your schema to make a nested query i.e. fetch data for a type ...