SQLTeam.com | Weblogs | Forums

Equivalent of make-table from Access in SSMS


#1

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?


#2
select ...
  into ...
  from ...
 where ...

#3

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.


#4

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.