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

Is generating replica at night a best practice and what is the cos

Generating 5 fresh different publications (each hold data for one distinct
region) over night, so client can download their selection replica.
Now what is the cost for such thing?
What is the over head per 1MB of data in terms of system tables and in terms
of download times on a typical intranet/internet.
Personal experience will be excellent input.
How fast is the connection? How fast are the boxes? What type of
Replication? Lots of variables. Test, test, test.
"Lottoman2000 NEWBE" <Lottoman2000NEWBE@.discussions.microsoft.com> wrote in
message news:A252FA00-25CE-413D-BDE0-7830BF3A7DD5@.microsoft.com...
> Generating 5 fresh different publications (each hold data for one distinct
> region) over night, so client can download their selection replica.
> Now what is the cost for such thing?
> What is the over head per 1MB of data in terms of system tables and in
terms
> of download times on a typical intranet/internet.
> Personal experience will be excellent input.
>