I would like to take an existing query in SSMS and render it as table, similar to how a user can turn a select query in Access into a table. I know I can INSERT INTO and existing table. But to do this from a query is quite different. Suggestions?
select ... into ... from ... where ...
bitsmed, you're indicating that the FROM can be a query as well as table source. And this I didn't think about. Thanks of course! You've realized this.
I'm saying, you can create a table with the data form a select statement, as I thought this was what you were looking for.