ToniChaffin Posted February 12, 2013 Share Posted February 12, 2013 (edited) I am running SQL 2008R2. How do I run a query on the result of a query without writing the initial results to a permanent table. An example would be great. I looked through the W3Schools SQL examples but did not see anything that seemed to relate.ThanksToni Edited February 12, 2013 by ToniChaffin Link to comment Share on other sites More sharing options...
justsomeguy Posted February 12, 2013 Share Posted February 12, 2013 You can run the query as a subquery and give the result a table alias name, like I showed in your other thread. Link to comment Share on other sites More sharing options...
ToniChaffin Posted February 13, 2013 Author Share Posted February 13, 2013 Again, my thanks for you assistance. I will try and work out how to do a sub-query based on your other responseRegardsT Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now