How? I've tried every variation that I can think of and it will never let me complete a nested query...Example:q = "(SELECT TOP 5 * FROM data WHERE ID > " & largeID & " ORDER BY ID)"This function ...

SELECT region, name, population FROM bbc x WHERE population <= ALL (SELECT population FROM bbc y WHERE y.region=x.region AND population>0) -- 2. Select the code that shows the countries belonging to ...

View an example of using nested FOR XML queries to shape the resulting XML. The two inner SELECT statements construct two <Price> elements, each with a PriceType attribute and XML that returns the ...

This paper describes a SQL Narrator designed using a Context-free Grammar that reads and generates narrations for queries using predefined templates. The SQL Narrator is able to narrate nested queries ...

IIRC most expensive RDBM's (Oracle, SQL server, DB/2) support nested tables in some form through UDTs.<BR><BR>I believe Oracle performs slightly worse with nested tables, but it can have some ...

This paper presents a technique for weaving temporal semantics into an SQL query. We assume that a query writer programs a query and then annotates the query with some temporal semantics, such as ...