Is it possible to query a prior query?

Is there some way to save a selection set in SQL
so that another SQL query can further refine the
prior query?Peter Olcott (olcott@.worldnet.att.net) writes:
> Is there some way to save a selection set in SQL
> so that another SQL query can further refine the
> prior query?

http://www.algonet.se/~sommar/share_data.html may give you some
suggestions.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||My suggestion is to dynamicly build view.You can query view as any other
table.You can also dynamicly build SQL SELECT statement and add conditions
in WHERE clause and execute it.sql